Sandip
Member since Jun 26, 2009
- Profile: /members/3688-sandip.htm
- URL: http://www.aikadajiba.blogspot.com
- Comments: 2
Recent Blog Comments By Sandip
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Jun 27, 2009 at 3:55 PM
I am not creating separate column. My trigger is on insert, so when I insert a record, first it will insert value of getdate(), and in trigger value get modified in required format. Sandip www.aikadajiba.blogspot.com... read more »
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Jun 26, 2009 at 3:43 AM
I developed the solution for date only from 'getdate()' function. Also this worked for me very effectively. Because I does not required to change the data type in the database or not required to write down different function for each time or not required to execute the same function for so many time... read more »