Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

Help displaying time retrieved from a database field

I have a SQL 2000 database that in one of my columns I record a date and time. The sql format looks like:

10/15/2004 8:00:00 AM

When I retrieve this data to view in a JSP page I get:

Fri Oct 15 00:00:00 EDT 2004

I am not concerned with formatting right now as I have that much figured out but what my issue is I need the actual hh:mm:ss that were entered into the database to display. For some reason my time is reset to midnight regardless of the entry I make.

My current display is without formatting but this is what I will use to just display the time entered:

<% SimpleDateFormat dt = new SimpleDateFormat ("hh:mm:ss a"); %>
<td><%=dt.format(the.Rider(getArrivalTime())%></td>

This works fine in displaying the time but it always reads 12:00:00 AM regradless of the entry in the database.

Any suggestions on where I could be going wrong in retrieving the time?

RCMB

0
rcmb
Asked:
rcmb
  • 4
  • 2
  • 2
  • +2
1 Solution
 
VenabiliCommented:
Hi rcmb,
How you read it from the database? And what type is the column in the database?
0
 
rcmbAuthor Commented:
This is the line that actually reads from the database

Date tmpArrivalTime = ConvertDate.SqlDateToUtilDate(rs.getDate("arrival_time"));
this.setArrivalTime(tmpArrivalTime);

The column in SQL is a shortdatetime

RCMB
0
 
TimYatesCommented:
<td><%=dt.format(the.Rider(getArrivalTime())%></td>

isn't valid java...

what's "the.Rider" do?  And there aren't enough ')'s
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
rcmbAuthor Commented:
The the.Rider is a vector that I used to gather the data from the sql query. Basically I have a sevlet that querys the database and then passes the data to a vector (the.Rider) and my jsp just grabs the data from the vector.

I am confused on the "isn't valid java" because it certainly works in displaying the information.

RCMB
0
 
rcmbAuthor Commented:
I also understand there are many ways "to skin the cat" in java. This is a simple jsp that just pre-populates a form so the user can update some data. If the time comes back as 12:00:00 AM vice the actual time then editing the information will do no good. The correct time will be recorded, as the system does now, but it never gets displayed.

RCMB
0
 
TimYatesCommented:
> I am confused on the "isn't valid java" because it certainly works in displaying the information.

But there aren't enough closing braces...

 <td><%=dt.format(the.Rider(getArrivalTime())%></td>
..............................^..............^.......................^

3 opening ones...

 <td><%=dt.format(the.Rider(getArrivalTime())%></td>
........................................................................^^

2 closing ones...

plus..  how is:

 <td><%= dt.format( Vector( getArrivalTime() ) %></td>

supposed to work? (which is pseudocode as to what your function is trying to do)  Maybe I am just getting confused though...  sorry if this is true

Back to my own SQL hell for me ;-)

Good luck!

Tim
0
 
Tommy BraasCommented:
Hi rcmb,
It seems to me that there is a problem in your conversion.

> Date tmpArrivalTime = ConvertDate.SqlDateToUtilDate(rs.getDate("arrival_time"));

Btw, why are you doing a conversion? java.sql.Date extends java.util.Date so there is no need to convert.

What is the field type in the database for the arrival_time? If it is DATE, then that is where the problem is as that data type only stores a date, no time.

Consider using TIMESTAMP instead. SQL Server's DATETIME is a bad choice as it is SQL Server specific.

Cheers!

\tt
0
 
objectsCommented:
and getDate() will only return the date portion regardless of whats in the database.
use getTimestamp() instead.
0
 
rcmbAuthor Commented:
getTimestamp was the answer. I did not need to convert anything else.

Thanks for the help.

RCMB
0
 
objectsCommented:
:)
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now