Home:ALL Converter>Oracle - Timestamp

Oracle - Timestamp

Ask Time:2013-09-18T14:11:59         Author:user2428207

Json Formatter

When importing columns of type "Timestamp" to an Oracle DB:

Import tbl:
02.09.13 00:00:00

After importing:

Oracle tbl:
02.09.13 08:23:44,000000000

In the Oracle tbl the type is also "Timestamp". How can I remove the ",000000000"?

Author:user2428207,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/18865048/oracle-timestamp
yy