Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 is there any way to display date......

Author  Topic 

asifbhura
Posting Yak Master

165 Posts

Posted - 2008-01-19 : 01:04:18
Hi,

in my system there is arabic date, so in table column it takes default date value in arabic.this is fine,

but i want to display this arabic date in english

is there any way to convert ?

Regards,
ASIF

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-01-19 : 08:07:01
what is the data type for this column ? Is it datetime ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-01-19 : 13:15:36
Look about the CONVERT function and Styles around 130+ something.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -