On 03/29/2015 08:52 PM, Maulik Shah wrote:
Dear Sir/Madam
how to convert float to timestamp in single select query
for exp. i have float as 1.251152515236 ,
test=> select to_timestamp(1.251152515236);
to_timestamp
---
1969-12-31 16:00:01.251153-08
The
On Sun, Mar 29, 2015 at 8:52 PM, Maulik Shah
wrote:
> Dear Sir/Madam
>
>
> how to convert float to timestamp in single select query
>
> for exp. i have float as 1.251152515236 ,
>
> i want to convert this to datetime and from datetime to timestamp...
> i.e. 02:22:044456
>
You imply that (float)
Dear Sir/Madam
how to convert float to timestamp in single select query
for exp. i have float as 1.251152515236 ,
i want to convert this to datetime and from datetime to timestamp...
i.e. 02:22:044456
I need sql query
It is actually .crd file made in xml , and i have query inside xml like
