-
1. Re: Converting String Date to Date Format on Google BigQuery Live Connection
Shinichiro MurakamiSep 13, 2018 8:30 AM (in response to Geoffrey Bell)
1 of 1 people found this helpfulHI Geoffrey,
Some datasource does not allow dateparse/makedate type of function.
If that's the case, only the way I know of is like this link. (Very trouble some though)
Converting a string to date (10.1)
Thanks,
Shin
-
2. Re: Converting String Date to Date Format on Google BigQuery Live Connection
Shinichiro MurakamiSep 14, 2018 12:37 PM (in response to Geoffrey Bell)
Just following up.
If you have further questions, please reply to this.
If you think problem is solved, please mark my answer as correct / helped to close the thread not from inbox but from originals post.
Thanks,
Shin
-
3. Re: Converting String Date to Date Format on Google BigQuery Live Connection
Geoffrey Bell Oct 3, 2018 6:00 AM (in response to Shinichiro Murakami)I ended up converting my BigQuery view to using the Standard SQL syntax and cast date as such:
CAST(CONCAT(SUBSTR(date,1,4),'-',SUBSTR(date,5,2),'-',SUBSTR(date,7,2)) AS DATE) AS Date,
This ended up being a more elegant solution for me but I can see your solution working for someone. I'll mark it as correct even though it was not the solution I ended up using.
-
4. Re: Converting String Date to Date Format on Google BigQuery Live Connection
Shinichiro MurakamiOct 3, 2018 6:57 AM (in response to Geoffrey Bell)
Hi Geoffrey
Thank you for sharing!
Shin