Date Prob

[amatuer]

In Sa the date format is dd/mm/yy. in sql server the format the format
is mm/dd/yy.
What code can be used to chnge the format to the SA date format
eithout chnging sql servers regional settings?

 

[Bob Barrows [MVP]]

In Sa the date format is dd/mm/yy. in sql server the format the format
is mm/dd/yy.
What code can be used to chnge the format to the SA date format
eithout chnging sql servers regional settings?

Use a nonambiguous format:
http://www.aspfaq.com/show.asp?id=2313 vbscript
http://www.aspfaq.com/show.asp?id=2040 help with dates
http://www.aspfaq.com/show.asp?id=2260 dd/mm/yyy confusion
http://www.aspfaq.com/show.asp?id=2023 date delimiters

 

[Aaron Bertrand [SQL Server MVP]]

Always use a non-regional date format, e.g. yyyymmdd. I use a function for
this, e.g.

function fixDate(dt)
fixDate = year(dt) & _
right("0" & month(dt),2) & _
right("0" & day(dt),2)
end function

Now, when I take the date from the server, or the date value from the
database, I can run it through this function and not have to worry about
trying to figure out if it is British or Canadian or American or Swahili...