Link to home
Start Free TrialLog in
Avatar of jskfan
jskfanFlag for Cyprus

asked on

SQL Query Select All fields with formatting

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



Thank you
ASKER CERTIFIED SOLUTION
Avatar of YZlat
YZlat
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jskfan

ASKER

Thank you