Dates Subtraction

Wrox Programmer Forums

		Wrox Programmer Forums > Database > SQL Language
Dates Subtraction

SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

November 28th, 2004, 01:50 PM

akhamis

akhamis is offline

Registered User

Join Date: Jun 2003

Posts: 6

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Dates Subtraction

Dear all,
i want to subtract dates and the result to be in seconds formate where the formate of the dates is(DD/MM/YYYY HH24:MM:SS)
taking in consedration that i'm suing an oracle data base.

Old

December 2nd, 2004, 04:38 PM

stuph

stuph is offline

Registered User

Join Date: Dec 2004

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Default

select datediff(ss, olderdate, newerdate)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Subtraction in an Access Query	pankaj_daga	Access	2	April 13th, 2007 06:49 AM
subtraction operator overload	arnie6	C++ Programming	0	April 19th, 2005 07:57 AM
dates	DARSIN	General .NET	4	January 14th, 2005 09:09 AM
subtraction	collie	SQL Server 2000	3	November 26th, 2004 01:03 AM
Dates	oathamm	Servlets	1	June 27th, 2003 05:43 AM