Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Newcomers » Newcomers » Date Conversion(Java Data Help)
Date Conversion [message #1748413] Tue, 22 November 2016 21:44
Keith Stramler is currently offline Keith StramlerFriend
Messages: 12
Registered: November 2015
Junior Member

I am new to Eclipse and Java. We have a Oracle database that has Tririga tables loaded. The Datetime columns in these tables are populated using Java.

I have written a report in Eclipse using sql and am getting the raw Java data when I select a datetime column. I have found a to_date conversion to use in SQL Developer, however, it is not working in Eclipse. Using the to_date conversion, I am able to tell what the date should be. See example below:

tribegindate convert date trienddate convert date
1402511400000 11-JUN-14 1402511400000 11-JUN-14

Here is my to_date syntax:
TO_DATE('01/01/1970 00:00:00','DD/MM/YYYY HH24:MI:SS') + (tribegindate /1000/60/60/24)

I am getting the data for "tribegindate" to print on my Eclipse report, but when I format the field through Eclipse, it does not print anything.

How can I get the Eclipse report to print dd/mm/yyyy converting the data that is currently there?

Thanks for any help.
Previous Topic:Terminal io
Next Topic:Jetty 9.3.14 Websocket CLOSED_ABNORMALLY Read EOF
Goto Forum:

Current Time: Sun Oct 25 18:05:55 GMT 2020

Powered by FUDForum. Page generated in 0.07131 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top