CODEWITHSUNDEEP
sql-serverasp-classic
GreenCat
GreenCat

Reputation: 167

Date format error SQL Server 2000+ASP

I have been successfully created new module in my system (localhost) but when I patched into server it having a problem on dateformat. As I noticed by default SQL Server will store in mm/dd/yy. For localhost the date was stored in mm/dd/yy (correct) but it reflected when I patch in server to dd/mm/yy.

Here is my code

SQL = "Insert into tbl(Date) value ('" & Date & "')

someone please help me..thanks

Upvotes: 0

Views: 578

Answers (1)

Griffin
Griffin

Reputation: 1595

Your server probably has different localization settings than your localhost.

Try formatting the date value in the form YYYY-MM-DD HH:MM:SS, which won't be misinterpreted.

Upvotes: 4

Related Questions