How to convert a string to a date in sybase

Question

I need to specify a date value in a sybase where clause  For example   select    from data where dateVal  lt   THE DATE

User · Answer

Use the convert function  for example   select   from data  where dateVal  lt  convert datetime   01 01 2008   103    Where the convert style  103  determines the date format to use

User · Answer

Here s a good reference on the different formatting you can use with regard to the date   http   infocenter sybase com help index jsp topic  com sybase infocenter dc38151 1510 html iqrefbb Convert htm

User · Answer

Several ways to accomplish that but be aware that your DB date format option  amp  date order option settings could affect the incoming format   Select     cast  2008-09-16  as date     convert date  16 09 2008  103     date  2008-09-16   from dummy

User · Answer

102 is the rule of thumb  convert  varchar  creat tms  102     2011

[sybase] How to convert a string to a date in sybase

Examples related to sybase

Examples related to type-conversion