Friday, 25 November 2022

Hive: year: Extract year part of the date

Signature

year(string date)
hive> SELECT year('2021-02-05 05:37:23');
OK
_c0
2021
Time taken: 0.047 seconds, Fetched: 1 row(s)

 

Previous                                                    Next                                                    Home

No comments:

Post a Comment