How can I convert the date/time format in a SQL query on Access insidea ASP script ?

[Bruno Baguette]

Hello,

I have to do a ASP/Access development but I'm completely locked on the
date/time formating.

How can I convert the display of a date/time type field (currently in
MM/DD/YYYY HH:MM) using a european format (DD/MM/YYYY HH:MM) in a SQL
query ?

I've tried using Format() and Convert() but it seems like theses
functions are not valid in a SQL query inside a ASP script.

Thanks in advance for your help !

 

[Guest]

In my experience with SQL dates, I've always had to format the date value as
'dd mmm yyyy', which equates to '21 Sep 2004'.

So, you would use Format(datefield, "dd mmm yyyy")