I've tried every iteration of a time zone ID and it is always ignored. Our server is running GMT but I'm trying to return Pacific time accounting for daylight savings. Running CloverETL Server 4.8.0.6 on a Linux server. Any ideas?
date2str(today(),"yyyy-MM-dd'T'HH:mm:ssZ","America/Los_Angeles");-
Hi Dflkid,
it appears that your date2str() function definition is missing the locale parameter which makes the timeZone parameter ignored. According to our documentation, the date2str() function accept these 3 definition formats:- string date2str(date input, string pattern);
- string date2str(date input, string pattern, string locale);
- string date2str(date input, string pattern, string locale, string timeZone);
In other words, using the timeZone parameter requires you to also define the locale. Having said that, I would suggest changing your function definition in the following way in order to achieve the desired result:date2str(today(),"yyyy-MM-dd'T'HH:mm:ssZ","en.US","America/Los_Angeles");
Kind regards, -
Hi Dflkid,
additionally, let me back up a little bit here. I would be curious as to where exactly you can see the improper time zone. Is it in the Data Inspector in CloverETL Designer or in an output of the graph? What I covered in my previous update concerns just the transformation string format and would affect the graph output. However, if you are seeing the improper time zone in the Data Inspector upon the graph run it could be caused just by the metadata definition (edit metadata > select your date-type field > Property section > Advanced > Time zone).
Best regards,
Please sign in to leave a comment.
Comments 3