Skip to Content
0
Former Member
May 15, 2008 at 05:28 AM

how to find entries for the particular month

1133 Views

hi all,

I have a table ZTOS4 where i store the trips, trips created timestamp.

in my selection screen , i give the month as parameter.

now i need to select the trips created for the select month. how can i put the select query???

select trips timestamp

from ztos4

where timestamp = month ??????? (as timestamp is date and time and month is 01,02,03,....12)

how to put the where condition?????

points will be rewarded

thanks in advance