Date/Time field

[Anonymous]

Hi guys,

Would anyone know how to strip out the time from a date/time field in a SQL table.

It is displayed like this in the table

2014-04-13 05:50:10.013

I would like to be able to analysis the data by time eg 05:50 from the example above.

Not sure if this is possible or not?

Thanks a lot

[anbu1984]

Yes. Create time range column based on your timestamp field in sql like this

select extract(hour from timestamp_fld) || '-' || (extract(hour from timestamp_fld)+1) from table;