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

  • Thread starter Thread starter Nathan Sokalski
  • Start date Start date
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.
 
Try just a space after you date and then your time value in "hh:mm:ss"
format.
 
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#
 
You must log in or register to reply here.

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

Parameter Query with DSum 1
Is there a Date Time Conversion from text? 2
Can't query datetime field formatted as m/d/yyyy 1
Date vs DateTime values 5
Access 2000 Query very slow compared to SQL Query Analyzer 5
Format DATETIME to Date in query on linked table 4
between datetime value from date time picker 3
Access pass-through query, SQL-92 combining strings: '&' does not 4

Back
Top