Skip to main content
Solved

Change date format in mass

  • August 23, 2023
  • 2 replies
  • 23 views

geo-x
Supporter
Forum|alt.badge.img+6

Hi community,

 

I've many postgres table in source, with differents structures. I would like to send them in Big Query, with, for each table, the same structure, so I thank to regroup source and regroup target to do that.

 

But, I would like, transform the date format for each postgres field. In fact I know to do that with DateTimeConverter but I've to declare all field one by one. It is possible to do that with "all date fields" ?

 

Thank you for your help.

Best answer by redgeographics

Unfortunately not, you'll need to specify all fields you want to use the DateTimeConverter on.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+62
  • Celebrity
  • Best Answer
  • August 23, 2023

Unfortunately not, you'll need to specify all fields you want to use the DateTimeConverter on.


geo-x
Supporter
Forum|alt.badge.img+6
  • Author
  • Supporter
  • August 23, 2023

Unfortunately not, you'll need to specify all fields you want to use the DateTimeConverter on.

Thank you redgeographics !