Querying Using Timestamp Components

Community Support
1

Hi guys

If I have a table where the ‘x’ column (say) is of type timestamp, how can I use it to restrict / subset queries?

Say if I want all results after 18:00;

select from x where `hh$timestamp > 18

Or a ranged query:

select from xwhere `hh$timestamp within (12;14)

Neither of the above work for me - not sure what Im missing…

Thanks!

– Rory

2

.. where (`hh$p) within ..

if you still have the problem, please mention you version/release.

thanks

3

Thanks Charlie - that did it.

Just curious (to aid my own understanding)  - what is the reason? I take it its some sort of precedence / binding rule?

Cheers

– Rory