Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SQL and TIMESTMP

Former Member

‎2009 Aug 06 9:05 AM

0 Likes
346

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

1 REPLY 1
Read only

sarbajitm
Contributor

‎2009 Aug 06 9:17 AM

0 Likes
300

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