Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DOS question

RE: DOS question

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Thu, 2 Dec 2004 08:03:55 +1100
Message-ID: <E10A27083F21674ABFAF6CD3D0BAC2F9120225@calbbsv025.cal.riotinto.org>


Here is an alternate CMD / batch approach that works:

:: get the time in format hhmmssxx, where 'xx' is hundredths of a =
second

        :: because want ssxx can not use time/t for /f "tokens=3D1-8 delims=3D:. " %%a in ('echo.^| time ^| find = "current"') do (

    set zhh=3D%%e
    set zmm=3D%%f
    set zss=3D%%g
    set zxx=3D%%h

)

if 10 GTR %zhh% set zhh=3D0%zhh%

:: assign the values to ztimefull

set ztimefull=3D%zdate%%zhh%%zmm%%zss%%zxx%

Something similar to the if could be used for your case That is, put hours into intermediate variable, check if less than 10, if = it is, prepend zero to the right most character.

HTH,
Bruce Reardon

-----Original Message-----
From: [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sinardy Xing Sent: Thursday, 2 December 2004 4:41 AM

I discover a bug in my script
time tag from "hhmmss" become " hmmss"



C:\Documents and Settings\sinardy>time
The current time is: 1:37:01.50
Enter the new time:

C:\Documents and Settings\sinardy>echo %time:~0,2%%time:~3,2%%time:~6,2%  13710

C:\Documents and Settings\sinardy>


my imp always fail from 12 am - 9:59 am

imp ...... log=3Dmylog 13710.log <--------- imp fail

anyone have solution?
Sinardy

NOTICE
This e-mail and any attachments are private and confidential and may = contain privileged information. If you are not an authorised recipient, = the copying or distribution of this e-mail and any attachments is = prohibited and you must not read, print or act in reliance on this = e-mail or attachments.
This notice should not be removed.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 01 2004 - 15:01:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US