The Jet SQL Syntax For Entering A Date And Time Into A DateTime Field

N

Nathan Sokalski

I need to enter the date and time into a DateTime field in my Access
database. I know how to enter just a date, but how do I enter a date and
time together? I could not find anything in the help file or on any
websites. Could someone let me know the syntax for entering a date and time
into a DateTime field together? Thanks.
 
V

Van T. Dinh

If you want to use explicit date and time value in JET, you also need to
enclose the explicit date and time value in hashes (#), e.g:

#12/31/2004 23:59:59#
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a Date Time Conversion from text? 2
Can't query datetime field formatted as m/d/yyyy 1
between datetime value from date time picker 3
Format DATETIME to Date in query on linked table 4
syntax for Week number 3
DateTime field 3
Access pass-through query, SQL-92 combining strings: '&' does not 4
Date() Criteria 3

Top