Ask Your Question
1

Convert CET date to UTC timezone

asked 2018-07-26 03:11:32 -0600

lucaz248 gravatar image

updated 2018-07-26 03:34:06 -0600

Hi! I'm ingesting data from FTP txt file with CET date timezone, and want to insert in mssql with UTC timezome.

Date format input in CET: "25/03/2018 01:00" I can convert this date to UTC, but the insert (JDBC driver) is changing it to system default timezone.

How can I reach this?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2018-08-01 06:45:24 -0600

lucaz248 gravatar image

updated 2018-08-01 10:05:31 -0600

metadaddy gravatar image

The solution I adapt for this is start SDC with -Duser.timezone=Etc/UTC

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-07-26 03:11:32 -0600

Seen: 73 times

Last updated: Aug 01