How can display date string value ?
I want to display date like this.

12 May 2004

strdate=Request.Form("strdate")
Response.write(strdate)

I use sql server 2000, how can use the strdate in the following
function so that it return string date in asp page
ie. 12 May 2004

what is the syntax to display string date in asp ?


convert(varchar(2),day(getdate())) + ' ' + DATENAME(month, getdate()) + ' ' + convert(varchar(4),year(getdate()))


regards.

Mateen

select CONVERT(varchar, getdate(), 106 ) AS 'DATE'

;) enjoy

thanks for response.

how can display the date in ASP page ?
i.e. 12 May 2004


it is display date in sql server,

Mateen

You can use

Day()
MonthName(month[,abbreviate])
Year()

functions to get that.

-Vijay G

day(now) & " " & monthname(month(now), True) & " " & year(now)

;)

thanks.