obvious mistakes.
Simon Anderson
-Original Message-
Sent: Thursday, April 11, 2002 14:08
To: Multiple recipients of list ORACLE-L
I want to subtract a minute from a date/time
How can I do this?
John
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INE
zanen1/External/MEY/NL)
[EMAIL PROTECTED] Subject: Re: subtract
Try this query:
select to_char (sysdate - (1/(24*60) * 5),'HH24:MI:SS') from dual;
^
this subtracts 5 mins from current date time.
On Thu, 11 Apr 2002, John Dunn wrote:
>
>
> I want to subtract a minute from a date/time
>
04:38 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: subtract minute from date/time
I want to subtract a minute from a date/time
How can I do this?
John
--
Please see
date_fld - 1/1440
Iain Nicoll
Test and Release
De-Regulated Services
Internal : 700 2331
External : 0141 568 2331
-Original Message-
Sent: Thursday, April 11, 2002 12:08 PM
To: Multiple recipients of list ORACLE-L
I want to subtract a minute from a date/time
How can I do this
select to_number(to_char(sysdate, 'MI')) from dual;
JP
On Thu 11. April 2002 13:08, you wrote:
> I want to subtract a minute from a date/time
>
> How can I do this?
>
> John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
INE
I know that if you have a date field then you can get the hour using the
formula
/60/60/24 thus to get the minutes will be /60/60
-Original Message-
Sent: Thursday, April 11, 2002 14:08
To: Multiple recipients of list ORACLE-L
I want to subtract a minute from a date/time
How can I
co.uk> cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: subtract minute from
date/t
* 60).
>- Original Message -
>From: John Dunn <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Thu, 11 Apr 2002 03:08:18
>
>I want to subtract a minute from a date/time
>
>How can I do this?
>
>John
>
&
I want to subtract a minute from a date/time
How can I do this?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
> -Original Message-
> From: Speaks, Chuck W. [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 23, 2001 12:06 PM
> To: Multiple recipients of list ORACLE-L
> Subject:
I need a trend on this query I need to keep the logfile names unique.
> Best case scenario is to append a date/time stamp to the logfile name as in
> 230820011200.txt (daymonthyeartime). Does anyone know how to do this with
> NT scripting? Any help would be greatly appreciated.
>
>
OS: NT 4.0
I have scheduled a query against a database that pipes results to a log
file.
Ex. Select * from any_table; >logfile.txt
Since I need a trend on this query I need to keep the logfile names unique.
Best case scenario is to append a date/time stamp to the logfile name as
Title: RE: Date / Time
Here is my attempt to display the difference between two dates in the format
:::
The two dates are dt1 and dt2
If dt1 is later than dt2 then result returned as negative.
It should work for differences of +/- 99 days - to increase the range,
change '09' at the
Sajid:
Try this piece. I use a version of it for my uptime.sql script:
TO_CHAR(TRUNC(date1 - date2)) || ' day(s), ' || TO_CHAR(TRUNC(MOD(date1
- date2 - 1, 1) * 24)) || ' hour(s), ' || TO_CHAR(TRUNC(((MOD(date1
- date2 - 1, 1) * 24) - (TRUNC(MOD(date1 - date2 - 1, 1) * 24)))
* 60)) || ' minute
Hi
The script below may help you - it will display different components in separate
columns, modify it with your two dates and proper table name and remove what you
don't need
select sysdate,
sysdate - to_date('0307200100', 'DDMMHH24MISS') diffr,
trunc(sysdate - to_date(
On Tue, Jul 10, 2001 at 05:26:09AM -0800, Sajid Iqbal wrote:
> I want to display the "time elapsed" between two dates - in days, hours,
> minutes and seconds.
>
> If I do "select date1 - date2", the result is : 12.0194907
>
> Is there a function that will turn the number of days into something
SELECT 12.0194907
,FLOOR((12.0194907*86400)/86400) || ':' ||
TO_CHAR(TO_DATE(ROUND(SUBSTR(12.0194907,INSTR(12.0194907,'.'))*86400),'s
'),'HH24:MI:SS')
FROM dual
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajend
Sajid Iqbal wrote:
>
> Hello All
>
> I want to display the "time elapsed" between two dates - in days, hours,
> minutes and seconds.
>
> If I do "select date1 - date2", the result is : 12.0194907
>
> Is there a function that will turn the number of days into something more
> legible? Ideally
Sajid,
Unfortunately, I ran into the same problem. I didn't find anything to do
it for me, either, so I had to write the pl/sql code. It is very long and
messy, but can be done. When I did it, I didn't even attempt the days
notation. Here is the code that I wrote:
date
Hello All
I want to display the "time elapsed" between two dates - in days, hours,
minutes and seconds.
If I do "select date1 - date2", the result is : 12.0194907
Is there a function that will turn the number of days into something more
legible? Ideally i'd like to do ;
"to_char(12.0194907,'D
d the code in the list archives.
In either case more details would help someone to help you
Witold
-Original Message-
can anyone help me with date + time in milliseconds.
i want to inpurt the data from a user in this format.
rgds
raj
--
Please see the official ORACLE-L
. You should in fact find the code in the list archives.
In either case more details would help someone to help you
Witold
-Original Message-
can anyone help me with date + time in milliseconds.
i want to inpurt the data from a user in this format.
rgds
raj
--
Please se
/ Administrator
Union Switch & Signal Inc
[EMAIL PROTECTED]
> -Original Message-
> From: Sinardy Xing [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 2:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: date+time in milliseconds
>
> Hi Raj
Hi Raj,
I never heard such time
Date can handle
century + year + month + day + hour + minute + second
but not milliseconds
Sinardy
-Original Message-
Sent: Tuesday, 8 May 2001 1:14 PM
To: LazyDBA mailing list
can anyone help me with date + time in milliseconds.
i want to inpurt the
I figure it out. It's based on Geogrian date. Just add it to "Jan-1-1970'
then use TO_CHAR to convert it
>From: [EMAIL PROTECTED]
>To: mai huynh <[EMAIL PROTECTED]>
>CC: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: date time
does the date time data in Oracle store in long number? From the application
interface, we enter data in format like '01/02/2001 10:30:00 PM' , when I
run the query, I get the result in long number as '915134070' . When I
compare it to SYSDATE ('SELECT * FROM
27 matches
Mail list logo