SELECT .. WHERE datetime ? (newbie)

  • Thread starter Thread starter Guido Franzke
  • Start date Start date
G

Guido Franzke

Hi NG,

I cannot execute the following SQL-Statement on a Access-MDB:

SELECT something,thedatetime FROM mytable WHERE thedatetime>'15.06.2005
03:05:00';

In my table is a column thedatetime with datatype Date/Time (german format).
I tried enclousing my datetime with " or ` or ´ instead of ' , but it
doesn't work either.

Can anyone help how to define the WHERE-clause?

Many thanx in advance,
Guido
 
My Outlook does not show the SQL command correctly, so here again:

SELECT something, thedatetime FROM mytable
WHERE thedatetime>'15.06.2005 03:05:00';

Date plus space plus time as string?
Please help, thanx, Guido
 
That's it, thank you, great!
Guido


Van T. Dinh said:
Not sure of German version of Access but explicit dates are usually
expressed in US format with date delimiter. Try:

... WHERE [DatTimeField] > #06/15/2005 03:05:00#

--
HTH
Van T. Dinh
MVP (Access)




Guido Franzke said:
Hi NG,

I cannot execute the following SQL-Statement on a Access-MDB:

SELECT something,thedatetime FROM mytable WHERE thedatetime>'15.06.2005
03:05:00';

In my table is a column thedatetime with datatype Date/Time (german
format).
I tried enclousing my datetime with " or ` or ´ instead of ' , but it
doesn't work either.

Can anyone help how to define the WHERE-clause?

Many thanx in advance,
Guido
Click to expand...
Click to expand...
 
Not sure of German version of Access but explicit dates are usually
expressed in US format with date delimiter. Try:

.... WHERE [DatTimeField] > #06/15/2005 03:05:00#
 
Back
Top