|
I'm trying to do a query like this on a table with a DATETIME column. SELECT * FROM table WHERE the_date = 2011-03-06T15:53:34.890-05:00 I have the following as an string input from an external source: 2011-03-06T15:53:34.890-05:00 I need to perform a query on my database table and extract the row which contains this same date. In my database it gets stored as a DATETIME and looks like the following: 2011-03-06 15:53:34.89 I can probably manipulate the outside input slightly ( like strip off the -5:00 ). But I can't figure out how to do a simple select with the datetime column. I found the convert function, and style 123 seems to match my needs but I can't get it to work. Here is the link to reference about style 123 |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 06 Mar '11, 21:07
question was seen: 17,976 times
last updated: 15 Mar '13, 17:16
This site is very much SQLAnywhere orientated, you'll probably do better to ask the question on one of Sybase's Enterprise newsgroups - see http://www.sybase.com/detail?id=1012843
SQLA and ASE are completely different products.
Just to add: In SQL Anywhere, you could simply cast to a DATE type, i.e. "SELECT * FROM table WHERE the_date = CAST('2011-03-06 15:53:34.123456' AS DATE)"