티스토리 뷰

공부

[Spark] string to date

승가비 2020. 12. 10. 10:31
728x90
SELECT date_format(to_timestamp("2019-10-22 00:00:00", "yyyy-MM-dd HH:mm:ss"), "yyyy-MM-dd'T'HH:mm:ss.SSS'Z')

https://stackoverflow.com/questions/58774777/how-to-format-date-in-spark-sql

 

How to format date in Spark SQL?

I need to transform this given date format: 2019-10-22 00:00:00 to this one: 2019-10-22T00:00:00.000Z I know this could be done in some DB via: In AWS Redshift, you can achieve this using the fol...

stackoverflow.com

 

728x90
저작자표시 비영리

'공부' 카테고리의 다른 글

[Python] call method by name of function  (0) 2020.12.10
[Python] beautify JSON  (0) 2020.12.10
[Spark] `foreach` vs `foreachPartition`  (0) 2020.12.10
[Sh] HDFS exists directory  (0) 2020.12.10
[Spark] Encounter SparkException “Cannot broadcast the table that is larger than 8GB”  (0) 2020.12.10
댓글