Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert( varchar(11), date_time, 103)
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01682711
Message ID:
01682712
Views:
31
Hi,

111 is Japan, 110 is US (different delimiters)

MartinaJ

>Hi,
>
>I know I should know it since I have this code in my application. But I would like to confirm that my understanding is still (after so many years) is correct.
>
>I have this code:
>
>Convert( varchar(11), date_time, 103)
>
>and
>
>Convert( varchar(11), date_time, 111)
>
>
>Does the above mean to convert a DATETIME column to a string of British format (103) and US format (111)?
>
>TIA
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform