Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using CONVERT() function
Message
 
 
À
07/02/2019 11:22:15
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01666022
Message ID:
01666038
Vues:
28
>>Thank you for both replies. What happens is that if the value of @TargetDate is NULL, all works.
>>Or if the value of @TargetDate from the XML type is American format (that works for many customers), all works.
>>But when I set the value in the ASP.NET application to the XML element TargetDate, I get error.
>>Why I do it this way is a long story. But it works for many years.
>>Now I need to figure where it breaks for the British date.
>
>"if the value of @TargetDate from the XML type is American format" - That is what I am saying, in the XML the format for a DateTime is fixed, regardless you are living in US or Turkey, or choose any place you like. It is like:
>
>2019-02-28T19:00:00+03:00
>
>I don't understand what does XML datetime have to do with ToShortTimeString(). Are you sure your XML is defining a DateTime type?

How do I convert a date (in the ASP.NET) into the format you described (above).
For example if I get the date value, as follows:
DateTime TargetDate = DateTime.Now;
How do I convert it to a string of the format "2019-02-28T19:00:00+03:00"?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform