Insert only date and only time in a table using SQL Server 2005

How to insert only date and only time in a table (column datatype is DateTime) using SQL Server 2005.

0


a source to share


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







All Articles