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.
| Author |
Topic |
|
mattt
Posting Yak Master
194 Posts |
 Posted - 2002-08-14 : 08:43:40
|
| Hi,I'm having trouble finding the right format to insert a time value only into a datetime field in SQL server. Trying to useINSERT INTO table_name VALUES ('10:00')Yields a datetime with a value of 01-Jan-1900 10:00:00 AM. I just want the time part, not the date!Cheers,Matt |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-08-14 : 09:01:10
|
| it is a DATETIME field. It stores the Date and Time. Let it do that.Don't try to change the way SQL Server stores it's data, leave your formatting to the presentation layer where you can just display the time part.Damian |
 |
|
|
|
|
|
INSERT time