Insert only date and only time in a table using SQL Server 2005
1 answer
As far as I know, date and time are always stored together. The internal representation is a number that represents the marks that are transmitted from a certain point.
You can of course filter the date information and time information from it and store it as a string, for example.
Or you can create a custom type as shown here: http://weblogs.sqlteam.com/jeffs/archive/2007/10/31/sql-server-2005-date-time-only-data-types.aspx
+2
a source to share