SQL Query Select All fields with formatting
I need to write SQL query to select all the fields from table1 with formatting few fields , Table 2 with formatting few fields.
How can I do that ?
For instance the field swith date and time will be formatted with the function UTCBigintToUTCTime"(startTime)
size in Bytes will be formated (will be divided by 1000) to get Kilobytes
the rest of the fields will not be formatted with the select query