how to insert Date (yyyy/mm/dd) to sql server

kiwibey · November 22nd, 2004, 11:21 PM

hi....
how can i insert the date (yyyy/mm/dd) by using asp <date()>
to sql server database..
so while i retieve the date from database i can preview in same format..
thank you

bey

happygv · November 23rd, 2004, 01:53 PM

Hi,
You can follow these steps.

Using ASP

Code:

Dim strDate
strDate = Year(Date()) & "-" & Month(Date()) & "-" & Day(Date())
Response.write strDate

While retrieving from database (SQL server)

Code:

Select Convert(varchar(10),DATE_COLUMN,121)

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection