Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQL server 2000 - Datetime field
9 views
Skip to first unread message
ikar...@gmail.com
Mar 3, 2008, 9:53:34 AM3/3/08
to
I was having an issue where I could not store just the time in the
datetime field.... it was always defaulting to 1/1/1900 for the date,
you can however go into the enterprise manager and manualy delete the
date part from the feild data and it look like it will "clear" that
1/1/1900 out, only retaining the time part.
datetime field.... it was always defaulting to 1/1/1900 for the date,
you can however go into the enterprise manager and manualy delete the
date part from the feild data and it look like it will "clear" that
1/1/1900 out, only retaining the time part.
On the back end what's happening is that it's setting the date to
1899-12-30 this may help some people that are struggeling to only use
a datetime field for time only.
I could not find any documentation out there on this.
Hope this help someone.
0 new messages