If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Java or SQL - Calculate difference between dates

BrokenArrows · 2005-04-30 16:12:06

Im currently writing a program that calculates the cost of a stay in a b&b. To do this i need to calculate the amount of time(in days) between the check in date and the check out date. Can this be done using java? I am getting the dates from an SQL server. I heard that there is an sql command that does this. If you know…

Options

30-04-2005 5:12pm

#1

BrokenArrows

Registered Users Posts: 7,498 ✭✭✭

Join Date: February 2005

Posts: 6933

Im currently writing a program that calculates the cost of a stay in a b&b.
To do this i need to calculate the amount of time(in days) between the check in date and the check out date.

Can this be done using java?
I am getting the dates from an SQL server. I heard that there is an sql command that does this. If you know how to do it in Java or SQL please post.

thanks.

0

Comments

Options
#2 30-04-2005 5:18pm
Sneaky_Russian

Closed Accounts Posts: 140 ✭✭

Join Date: April 2005

Posts: 117

Hey man......

look at datediff function in t-sql

0
Options
#3 30-04-2005 5:33pm
BrokenArrows

Registered Users Posts: 7,498 ✭✭✭

Join Date: February 2005

Posts: 6933

thanks man worked like a charm

0