|
Database | Welcome to the Teradata Forums.
Read the
guidelines on posting.
Email notifications and RSS feeds are available, and also a chronological list of all forum activity. |
|
|
|
|
Database | Welcome to the Teradata Forums.
Read the
guidelines on posting.
Email notifications and RSS feeds are available, and also a chronological list of all forum activity. |
|
|
Hi
when we are try to convert the Decimal value to Time format . im using the mentioned logic
( (PRINT_TIME /100) (FORMAT '999999') (CHAR(6)) (TIME(0)) )
but for some values im facing an issue .
ex: 1233812
1233793
when it is converting to time it is showing me the same value . That is
1233812 ------ 01:23:38
1233793 -------- 01:23:38 it should be 01:23:37 .
please suggest me how to resolve it .