Tag: TIMESTAMP

Informatica Powercenter : Convert String to timestamp with milliseconds

String to Timestamp

When you want to convert a String to a timestamp with milliseconds and you are only getting zero’s for milliseconds in your database make sure that the following option is disabled in the session (Config Object tab) : If this is enabled the milliseconds will be truncated. You can use the following formula to convert …

Continue reading

Convert UTC datetime from SQL Server to local timezone (CET) in Oracle.

For a project at a customer I had to load data from a SQL SERVER database to a Oracle database. It turned out that the SQL SERVER database stored the date and time data in UTC. This became apparent when the data was reported via Business Objects and all the date time data was off …

Continue reading

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close