Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 T-SQL function to extract the time from a date/time field?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-07 : 17:15:40
Dave writes "I have a date/time field in a table that uses GetDate() to assign the default date value each time a record is inserted.

I know about the T-SQL Month(), Day(), etc. functions, and was wondering if there was such a function to extract the time portion of the date/time value without having to resort to parsing?

thanks in advance,
Dave"
   

- Advertisement -