asp date > mysql date format

[mthompo]

ok have written some script that changes
standard UK date format dd/mm/yyyy to mysql query
format yyyymmdd

whenstart =date()
motdaynumsql = day(whenstart)
motmonthsql = month(whenstart)
motyearsql = year(whenstart)
'sql start
daysql = motdaynumsql
if daysql < 10 then 
daysql = "0" & daysql
end if
monthsql = motmonthsql
if monthsql < 10 then 
monthsql = "0" & monthsql
end if
'join together
dstartdatesql = motyear & monthsql & daysql

is there a better way of doing this?

 

[mthompo]

oops year var was wrong - should read

whenstart =date()
motdaynumsql = day(whenstart)
motmonthsql = month(whenstart)
motyearsql = year(whenstart)
'sql start
daysql = motdaynumsql
if daysql < 10 then 
daysql = "0" & daysql
end if
monthsql = motmonthsql
if monthsql < 10 then 
monthsql = "0" & monthsql
end if
'join together
dstartdatesql = motyearsql & monthsql & daysql

 

[DotNetGnat]

look into cast() and convert() functions...

-DNG

 

[mthompo]

many thanks