SQL and TIMESTMP

Former Member — Thu, 06 Aug 2009 08:05:09 GMT

Hi experts,

I have value as l_date and would like to use SELECT statement over table to receive rows which correspond to field which is as TIMESTMP.

Can i use something as SELECT * FROM table WHERE CONVERT ( timestmp to date ) = l_date ?

I can use e.g. CONVERT DATE in ABAP, but i would like do it in SELECT , is it possible ?

Thanks

Martin

Re: SQL and TIMESTMP

sarbajitm — Thu, 06 Aug 2009 08:17:39 GMT

Hi,

try to use CONVERT in ABAP to convert the date in a specific format

then in SQL Statement use LIKE operator.

May be in this way you can get your desired output.

Regards.

Edited by: Sarbajit Majumdar on Aug 6, 2009 1:48 PM