I’m a bit green with SQL and currently using Toad for data analysts. I don’t believe I asked the correct question before or didn’t give accurate information.
I am trying to pull data for the date ranges from 12-5-2011 to 01-25-2012. The date column that I am pulling from has a format that shows as “1,327,512,651. or 1327512651(not sure of format name)” and exports to excel in the same format. I would like to pull the data with the date column showing a dd-mon-yyyy format in a column and another column showing a hh:mm format so I can calculate average time in hours. Can anyone assist?