Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

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:


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

asked 06 Mar '11, 21:07

henny%20penny's gravatar image

henny penny
accept rate: 0%

edited 15 Mar '13, 17:16

Mark%20Culp's gravatar image

Mark Culp

This site is very much SQLAnywhere orientated, you'll probably do better to ask the question on one of Sybase's Enterprise newsgroups - see

SQLA and ASE are completely different products.

(07 Mar '11, 11:36) Justin Willey
Comment Text Removed

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)"

(08 Mar '11, 08:09) Volker Barth
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • 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: 19,184 times

last updated: 15 Mar '13, 17:16