If not, please post a little sample data (CREATE TABLE and INSERT statements, relevant columns only) for all tables involved, and also post the results you want from that data. If thats supposed to represent January 13, 1998, then you can use. ![]() I can also imagine that no math at all has to be done, but until we see actual data, actual table definitions, and actual desired output, were all just guessing.ĭepending on the time zone, it corresponds to 21:36:20 on August 9, 2005. It seems fairly easy, but Im failing it, because Im a beginner.īelow is kinda of what Im looking for.the query isnt correct, its just an example: Select systemname, datetimecreated, datetime modified ( would like the date and time stamp to show as ( example 06142008 12:55 PM) from systemstore where datetimecreated and systemtypegm order by descending then I would like to export to excel. ![]() Lastly, I would like to export the output it to an excel spreadsheet. Learn from thousands of community experts Get answers to your technical questions Share your knowledge with peers 1,060,000 Active Users 1,100,000 Answered Questions Register Today. Register Log In Join the worlds largest interactive community dedicated to Oracle technologies. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |