SQL with Timestamp Filtering
Published by: rpgprogrammer on 30 Aug 2013 view comments(2)
Need a expert advice,
I want to find all records from a given file which falls between two timestamp
select * from filename where filefield.timz between '2013-08-31-03.41.51.036000' and '2013-08-31-03.41.49.040000'. Seems the timestamp values are not numeric so bit confused..