| Subject | CAST() as TimeStamp / Date need in regional setting |
|---|---|
| Author | Bhavbhuti Nathwani |
| Post date | 2007-11-24T07:52:09Z |
Hi all
I recently used CAST(tDt AS DATE) (TIMESTAMP field as DATE) in one of
my SELECT and the date came up as 2007-11-24, is it possible to get
the date in the computer's regional setting for eg. 24/11/2007?
Thanks
Regards
Bhavbhuti
I recently used CAST(tDt AS DATE) (TIMESTAMP field as DATE) in one of
my SELECT and the date came up as 2007-11-24, is it possible to get
the date in the computer's regional setting for eg. 24/11/2007?
Thanks
Regards
Bhavbhuti