Solved

UTC date

Posted on 2006-06-20
1
489 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

Check out this step-by-step guide for asking an anonymous question on Experts Exchange.
We asked our MSP customer base what their favorite tools were and how they help them serve clients. We focused our questions on favorite tools in the following categories: >PSA tools >RMM tools >Alert management tools >Communication tools and Mo…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

739 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