format date

[JT]

i have a date stored in my db in this format: 2005-03-15 00:00:00.000

however, i want to display this date on my .asp page in this format: 03/05

is there a quick function to do this?

tmia

jt

 

[Ray at]

sDate = "2005-03-15 00:00:00.000"
sDate = Split(sDate, " ")(0)
sDate = Right("0" & Month(sDate), 2) & "/" & Right("0" & Day(sDate), 2)
Response.write sDAte

Ray at work

 

[Aaron Bertrand - MVP]

i have a date stored in my db in this format: 2005-03-15 00:00:00.000

Stored in what db, SQL Server? This is not how it's stored. Internally,
it's stored as two integer values (one for the date, and one for the time).
What you are seeing is some client tool's representation format (Enterprise
Manager, perhaps?).

To get it out the way you like, you can handle the formatting on the client
as Ray suggests, or you can handle it in the database as follows:

SELECT RIGHT('0'+RTRIM(MONTH(someColumn)), 2)
+ '/' + RIGHT('0'+RTRIM(YEAR(someColumn)), 2)
FROM someTable