stretch73
asked on
SmallDateTime storing midnight (12:00 AM) problem
I'm storing a series of records in an SQL 2000 database and I'm having trouble with storing midnight, 12:00 AM. I'm passing in '12:00:00 AM' but for some reason it doesn't show up in the database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It may be in the database, and not showing up in Enterprise Manager, but it's not coming back when I pull a recordset either.
>>it's not coming back when I pull a recordset either. <<
In Query Analyzer? Show your code.
In Query Analyzer? Show your code.
ASKER
There was a delay on the postings, you were right it's in there it just doesn't display. Thanks for the help, this was driving me nuts.
N
N
I think you mean it is not displayed in Enterprise Manager. It is in the database.