How to round current time in teradata and insert into timestamp(6) feilds
Posted
by
user3471254
on Stack Overflow
See other posts from Stack Overflow
or by user3471254
Published on 2014-06-08T08:51:32Z
Indexed on
2014/06/08
9:24 UTC
Read the original article
Hit count: 251
I have a table with date fields of timestamp(6)
fields .
create table test_time
(
t1 timestamp(6) format 'mm/dd/yyyy hh:mm:si' ,
);
I want to insert into this table with current date and time rounded.
i.e. say for example if the current date time is 08/07/2014 10:34:56
then the value in the table should be 08/07/2014 10:00:00
.
(or) if current data and time is 08/07/2014 10:54:56
then also the value should be
08/07/2014 10:34:56
© Stack Overflow or respective owner