Avatar of pothios
pothios asked on

Time Stamp help please :(

hi, yesterday i manage to solve my timestamp problem but it seems like its not working again :/
i keep getting 43672 for the diff :(

Timestamp convertedDate = new java.sql.Timestamp(tmgr.getRecordDate(sql).getTime());
long diff;
java.util.Date now;
now = new java.util.Date();
diff = now.getTime() - convertedDate.getTime(); // difference in milliseconds
diff = diff / 1000; // difference in seconds;

Open in new window

Java

Avatar of undefined
Last Comment
CEHJ

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
humanonomics

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
anmalaver

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
humanonomics

@anmalaver, thats fine tmgr.getRecordDate(sql).getTime() will return time in long format, and Timestamp has a constructor that accepts time in long format.What I want to know is what time is stored in database.

The reason being the above code is working absolutely fine for me.

Thanks
humanonomics

@anmalaver

Ignore my comment, I misread you comment. Sorry for that.

:)
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck