Hi,
I've been facing some issues in using date_add()
I have column 'day_key' that is short integer and stores day keys with respect
to 1985/01/01.
I need to extract actual date from this column.
Date_add('1985/01/01',day_key)
However I get an error saying the second argument needs integer.
I also did
Date_add('1985/01/01',cast(day_key as int))
Resulted in an error saying the column is short.
Please help me with this.
Thanks
Regards,
Yashwanth M | +91 8884 177 884 |www.mu-sigma.com<http://www.mu-sigma.com/> |
Disclaimer: http://www.mu-sigma.com/disclaimer.html
