Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting a date and time from Oracle

General

Getting a date and time from Oracle

by  Glowball  Posted    (Edited  )
Sometimes no matter what you try you can't get Oracle to give you a date and time from your database. Even SYSDATE on its own won't work. Try this code!
Code: 
<cfquery name="get" datasource="myDSN">
SELECT TO_CHAR(theDate,'MM-DD-YYYY HH:MI:SS AM') "formattedDate" FROM tablename
</cfquery>
<cfoutput query="get">
    #get.formattedDate#<br>
</cfoutput>
This assumes the table is named [tt]tablename[/tt] and has a column named [tt]theDate[/tt].
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top