Solved

UTC date

Posted on 2006-06-20
1
486 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

For months I had no idea how to 'discover' the IP address of the other end of a link (without asking someone who knows), and it drove me batty. Think about it. You can't use Cisco Discovery Protocol (CDP) because it's not implemented on the ASAs.…
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 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