I would like to ask you guys if anyone of you had this trouble before.
In SQL I read the create time of the file like
exec master.dbo.xp_cmdshell 'dir C:\ /TC'
which gives me;
07/14/2009 04:20 <DIR> Windows
As you noticed the date format of this is mm/dd/yyyy although it's set to dd/mm/yyyy format in region settings.
Same script on different PC returns
14/07/2009 04:20 <DIR> Windows
Is there any setting for this you guys aware ?
And is there any method to change the format of create time of the command ?