• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

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.
0
stretch73
Asked:
stretch73
  • 3
  • 2
1 Solution
 
Anthony PerkinsCommented:
>>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.
0
 
Anthony PerkinsCommented:
And I should have added, that if you go to Query Analyzer and do a select it will display as (for example)
2004-03-30 00:00:00
0
 
stretch73Author 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.  
0
 
Anthony PerkinsCommented:
>>it's not coming back when I pull a recordset either. <<
In Query Analyzer?  Show your code.
0
 
stretch73Author 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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now