Topic
  • No replies
SystemAdmin
SystemAdmin
6184 Posts

Pinned topic Converting numeric field to date format with MID and RIGHT functions

‏2013-03-15T06:51:31Z |
Hello,
I need to convert a 16 bytes (2013030823372931) numeric field to a dateformat (YYMMDD) and timeformat (24HHMMSS. So I need to use the MID function (3,6 ) for the DATE and RIGHT function for the TIME. I'm having trouble using these function in converting numeric to date format, any suggstion will be greatly appreciated.