How to format datetime to mysql format?
i want the time format to be yyyy-mm-dd hh:mm:ss

in vb6 i can use


but in asp, format function is not usable.
Help

One way is to seperate the datetime and rebuild it as string.
If the date is like 03/02/2006 (MMDDYYYY) , break it to
DD = 02
MM = 03
YYYY = 2006

From here you can just manipulate the string.

mydate = DD & "-" & MM & "-" & YYYY
which looks like , 02-03-2006.

Just a suggestion anyway...

dude, i thought the format function is like this:

Format(Now(), "dd MM yyyy")

notice Now() is before the desired format string. and be careful with the CASE. d is DAY, M for MONTH and m for minutes.

i'm trying this new thing i came out with. it's for .NET apps. dunno whether it's good or not. do try and give comments if you may.



function US_date_to_MY accepts normal datetime and returns desired datetime format, dd MMM yyyy.

the other function accepts dd MMM yyyy (also works for various combinations as long as it's in d/M/y sequence).

so far as i tested, the functions work both in web and window apps.

visual basic

format(now,"dd-mm-yyyy")


C#

now.toString("dd-mm-yyyy");

how about asp? i'm using asp, and the format code doesnt work for asp.

How about my method?
I assume you want to save the datetime into your database, then how about formating it in the sql statement where the mysql has better formating option.

asp is Vb what

Format now working?

can you pls ellaborate on that? formatting in a sql statement? you mean, calling for the desired format readily in a sql statement, using sql syntax?

Emm, something like

mydate = "17/03/2004"

sql = "insert into Tbl(mydate) "
sql = sql & " values(convert(datetime, ' " & mydate & "', 103))"

But this done using mssql, dunno if mysql have the same function.