HOW to reterive specific datetime values from sybase iq

You need either to choose one of the styles below or to use convert function twice (one for date and another one for time and concatenate them).

CONVERT( datatype, expression [ , format-style ] )

datatype   The data type to which the expression is converted.

expression   The expression to be converted.

format-style   The style code to apply to the output value. Use this parameter when converting strings to date or time data types, and vice versa. The table below shows the supported style codes, followed by a representation of the output format produced by that style code. The style codes are separated into two columns, depending on whether the century is included in the output format (for example, 06 versus 2006).

Without century (yy) style codes      With century (yyyy) style codes      Output format
-      0 or 100      Mmm dd yyyy hh:nnAA
1      101      mm/dd/yy[yy]
2      102      [yy]yy.mm.dd
3      103      dd/mm/yy[yy]
4      104      dd.mm.yy[yy]
5      105      dd-mm-yy[yy]
6      106      dd Mmm yy[yy]
7      107      Mmm dd, yy[yy]
8      108      hh:nn:ss
-      9 or 109      Mmm dd yyyy hh:nn:ss:sssAA
10      110      mm-dd-yy[yy]
11      111      [yy]yy/mm/dd
12      112      [yy]yymmdd
-      13 or 113      dd Mmm yyyy hh:nn:ss:sss (24 hour clock, Europe default + milliseconds, 4-digit year )
-      14 or 114      hh:nn:ss:sss (24 hour clock)
-      20 or 120      yyyy-mm-dd hh:nn:ss (24-hour clock, ODBC canonical, 4-digit year)
-      21 or 121      yyyy-mm-dd hh:nn:ss.sss (24 hour clock, ODBC canonical with milliseconds, 4-digit year )