Hive: dayofmonth: Extract day information from date

Signature

dayofmonth(string date)

hive> SELECT dayofmonth('2021-02-05 05:37:23');
OK
_c0
5
Time taken: 0.045 seconds, Fetched: 1 row(s)

 

 

Previous                                                    Next                                                    Home