using between with timestamps

[jtranex0]

hello,

iam trying to use a query so it presents all timestamps in the "between" condition using %.

e.g.

timestamps are in format
040206181748

select * from entries where mytimestamp between '04%' and '04%'

hopefully this should print all results for the year 2004, but for the query it returns an empty set, is there anything wrong?

thanks.

 

[QatQat]

you must use a

WHERE substring(timestamp_field, 1, 2) = 04

or if you want a range of months

WHERE substring(timestamp_field, 3, 2) >= 04 and
substring(timestamp_field, 3, 2) <= 07

I think you can also use BETWEEN with substring


Bye

QatQat

Life is what happens when you are making other plans.

 

[KarveR]

select * from entries where mytimestamp like '04%';

if you are using the same value for both, possibly faster.

otherwise, what QatQat said.


______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.