We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SmallDateTime storing midnight (12:00 AM) problem

stretch73
stretch73 asked
on
Medium Priority
325 Views
Last Modified: 2012-06-27
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.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2012

Commented:
>>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.
CERTIFIED EXPERT
Top Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
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.  
CERTIFIED EXPERT
Top Expert 2012

Commented:
>>it's not coming back when I pull a recordset either. <<
In Query Analyzer?  Show your code.

Author

Commented:
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
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.