Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Query using Toad for Oracle - Select query to convert UNix date and time to everyday format

user10550685Aug 14 2015 — edited Aug 18 2015

Hello, I'm trying to write a simple select query USING TOAD for ORACLE that pulls information from a "system_store" table, where I need to find the real date and time stamp for columns " date_time_created" and "date_time_modified", including the "system_name" column. The date range for the query, aka datetime_created, is only for the year of 2008 to group any application from the column "system_type"  that the name is "GM".  Lastly, I would like to export the output it to an excel spreadsheet.

Can anyone help with it.  It seems fairly easy, but I'm failing it, because I'm a beginner.

Thanks in advance.

Below is kinda of what I'm looking for...the query isn't correct, it's just an example:

Select system_name, date_time_created, date_time modified //////( would like the date and time stamp to show as ( example 06/14/2008 12:55 PM)

from system_store

where date_time_created = ???

and system_type='gm'

order by descending

then I would like to export to excel

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2015
Added on Aug 14 2015
9 comments
4,370 views