|
date format that asp returns is dd/mm/yyy bat when i want to build a query string to select from my db in sql server i have this error:
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
date format in sql is yyy/mm/dd;
plz help me,
|
|
|
hi misneg,
try this ASP code :-
<%
Dim tempDate, tempMonth, tempDay, tempYear, tempStr
mDate = Date()
tempDate = REPLACE(tempDate, "/index.html", "")
tempMonth = LEFT(mDate, 2)
tempStr = LEFT(mDate, 4)
tempDay = RIGHT(mTemp, 2)
IF LEN(tempDate) = 8 Then
tempYear = RIGHT(tempDate, 4)
ELSE
tempYear = RIGHT(tempDate, 2)
END IF
tempDate = tempDay & "/index.html" & tempMonth & "/index.html" & tempYear
Response.Write(tempDate)
%>
|
|
|
|
|
|
|
|
|
|