| DESCRIBE FUNCTION last_day; |
| DESCRIBE FUNCTION EXTENDED last_day; |
| |
| explain select last_day('2015-02-05'); |
| |
| select |
| last_day('2014-01-01'), |
| last_day('2014-01-14'), |
| last_day('2014-01-31'), |
| last_day('2014-02-02'), |
| last_day('2014-02-28'), |
| last_day('2016-02-03'), |
| last_day('2016-02-28'), |
| last_day('2016-02-29'), |
| last_day(cast(null as string)); |
| |
| |
| select |
| last_day('2014-01-01 10:30:45'), |
| last_day('2014-01-14 10:30:45'), |
| last_day('2014-01-31 10:30:45'), |
| last_day('2014-02-02 10:30:45'), |
| last_day('2014-02-28 10:30:45'), |
| last_day('2016-02-03 10:30:45'), |
| last_day('2016-02-28 10:30:45'), |
| last_day('2016-02-29 10:30:45'), |
| last_day(cast(null as string)); |
| |
| |
| select |
| last_day(cast('2014-01-01' as date)), |
| last_day(cast('2014-01-14' as date)), |
| last_day(cast('2014-01-31' as date)), |
| last_day(cast('2014-02-02' as date)), |
| last_day(cast('2014-02-28' as date)), |
| last_day(cast('2016-02-03' as date)), |
| last_day(cast('2016-02-28' as date)), |
| last_day(cast('2016-02-29' as date)), |
| last_day(cast(null as date)); |
| |
| select |
| last_day(cast('2014-01-01 10:30:45' as timestamp)), |
| last_day(cast('2014-01-14 10:30:45' as timestamp)), |
| last_day(cast('2014-01-31 10:30:45' as timestamp)), |
| last_day(cast('2014-02-02 10:30:45' as timestamp)), |
| last_day(cast('2014-02-28 10:30:45' as timestamp)), |
| last_day(cast('2016-02-03 10:30:45' as timestamp)), |
| last_day(cast('2016-02-28 10:30:45' as timestamp)), |
| last_day(cast('2016-02-29 10:30:45' as timestamp)), |
| last_day(cast(null as timestamp)); |