How to get date time to display like 01/01/2005 16:14:10?

[ynott]

How to get date time to display like 01/01/2005 16:14:10? mm/dd/yyyy

Here's something that I found works against an Oracle database.
However, I'm not getting the same results against a SQL 2000 database.
Can anyone point out the correction needed? With the following, the
time displays correctly, but no date at all.

<%d=formatdatetime(rs2("Begin_Time"), 2)
if mid(d,2,1)="/" then d="0" & d
if mid(d,5,1)="/" then d=left(d,3) & "0" & mid(d,4)
Response.Write (d) & "&nbsp;"
Response.Write formatdatetime(rs2("Begin_Time"), 4)
if second(rs2("Begin_Time")) < 10 then
Response.Write ":0" & second(rs2("Begin_Time"))
else
Response.Write ":" & second(rs2("Begin_Time"))
end if%>

TIA

 

[vongrunt]

What you got and what you should get? Also: what is your current locale ID (as returned by getLocale() function)?

As long as Begin_time is of type date or datetime, database shouldn't matter.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)