Solved

UTC date

Posted on 2006-06-20
1
485 Views
Last Modified: 2012-06-27
Hello,

I am passing in a date formatted like this "2006-07-18T16:48:00" to a datetime field in a stored proc but receive an error about varchar conversion. The date was formatted in C# like this:

dt1.ToUniversalTime().ToString("s", _Culture)

What is the best way to handle this in Sybase?


0
Comment
Question by:tmueller18
1 Comment
 
LVL 10

Accepted Solution

by:
bret earned 500 total points
ID: 16948575
Not sure about "best" way, but a good way may be to use str_replace to replace "T" with a space before the conversion.

-bret
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Note: This is the second blog post in a series on email clearinghouses (https://www.xmatters.com/alert-management/blog-email-has-failed-us?utm_campaign=70138000000ydLoAAI&utm_source=exex&utm_medium=article&utm_content=blog-post).   Every month t…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
A short film showing how OnPage and Connectwise integration works.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now