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.
 
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#
 
Back
Top