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

  • Thread starter Thread starter Bruno Baguette
  • Start date Start date
B

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 !
 
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")
 
Back
Top