Link to home
Start Free TrialLog in
Avatar of stretch73
stretch73Flag for United States of America

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.
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

>>but for some reason it doesn't show up in the database<<
I think you mean it is not displayed in Enterprise Manager.  It is in the database.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of stretch73

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.
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