Posted by iulian.ilea on 10/25/06 06:42

Is correct to have a varchar field and insert dates of type dd/mm/yyyy
into it? I choose this method because I have an application that runs
on more than one server. So, if I used a datetime field (MSSQL Server)
it worked on my test machine. If I run the same application on another
machine with different regional settings is not working. I tried with
date_default_timezone_set to change timezone but is not changing. After
date_default_timezone_get the result was the new timezone but the dates
were the same. So, after that I changed all datetime fields into
varchar and used query's like this (see bellow) where I have date
operations.

My question: is correct to to this? Because is working on one machine
and on another one I get an error that it can't convert char to
datetime. My guess is that I left a datetime field unchanged or my
ideea about using varchar instead of datetime is completely wrong.

SELECT * FROM DocD WHERE CONVERT(datetime,created,101) BETWEEN
CONVERT(datetime,'10/25/2006',101) AND
CONVERT(datetime,'10/25/2006',101) ORDER BY cName ASC,
CONVERT(datetime,created,101) DESC, DocID DESC

[Back to original message]