Include milliseconds in time literal in SQL?

  • Thread starter Thread starter Armin Zingler
  • Start date Start date
A

Armin Zingler

Hi,

in a datetime field in a database, the date/time value is
11/21/2005 09:30:45.753. The interesting part is the seconds. It's 45.753
seconds. How do I query for this exact value? Maximum resolution seems to be
seconds: "...where value=#21/11/2005 09:30:45#"
This is not allowed: "...where value=#21/11/2005 09:30:45.753#
This not, too: "...where value=#21/11/2005 09:30:45:753#

So, how do I include the milliseconds in a time literal in an SQL?


Armin
 
SELECT * FROM TABLE
WHERE VALUE='2005-11-21 07:05:07.810'

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***********************************************
Think Outside the Box!
***********************************************
 
Cowboy (Gregory A. Beamer) said:
SELECT * FROM TABLE
WHERE VALUE='2005-11-21 07:05:07.810'
Click to expand...

This is not a valid date/time format. Date/time literals must be enclosed in
'#'. The ''' indicates a string, thus I get a data type mismatch error.


Armin
 
Armin,

You know that your litterals are wrong, you use European standard, the
literarls are in the current versions still all based on USA notation.

(and therefore I don't like them, gives me to much confusion)

Just to bring your attention on.

Cor
 
Cor Ligthert said:
Armin,

You know that your litterals are wrong, you use European standard,
the literarls are in the current versions still all based on USA
notation.

(and therefore I don't like them, gives me to much confusion)

Just to bring your attention on.
Click to expand...


You're right. I mistyped in the posting only. Must have been
11/21/2005 of course. Thanks!


Armin
 
Back
Top