If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hi,
are you sure 11/10/2007 (11 October) is correct? I thing there is 11.10.2007 isn't it=
Try using CHAR(date_field,format) command.
'Format' can be: ISO, USA, EUR, JIS, or LOCAL
Hope this helps,
Grofaty

Hi,
have you checked Windows Control Panel | Regional and Language Options?
Check all of the setting in Regional and Language Option in production and test system. It looks like there is a problem in OS settings.
Hope this helps,
Grofaty