Re: %timestamp ??

["HauserBirgitta" <Hauser@xxxxxxxxxxxxxxx>]

Hi,

the RPG built-in-function %TimeStamp() only fills and uses only the first 3 
digits of the microseconds. If you need all six digits, you should use the 
SQL special value CURRENT_TIMESTAMP.

C/EXEC SQL   Set :MyTimeStamp = Current_TimeStamp
C/End-Exec

Mit freunlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les 
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)




----- Original Message ----- 
From: "Barbara Morris" <bmorris@xxxxxxxxxx>
To: <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, November 21, 2006 04:09
Subject: Re: %timestamp ??


> Jim Wiant wrote in MIDRANGE-L Tue, 21 Nov 2006:
> > I usually use MyTimeStamp = %DATE + %TIME and that gives me the current
> > time (doesn't get the milliseconds though)
>
> Hi Jim, much safer to use MytimeStamp = %TIMESTAMP.
>
> If you also need the matching date and time, you could then do
>   MyDate = %DATE(MyTimeStamp);
>   MyTime = %TIME(MyTimeStamp);
>
> Doing %DATE and %TIME separately, you might do the %DATE one side of
> midnight and the %TIME the other side of midnight, giving you 24 hours
> too early, say
>   2006-10-20-00.00.01
> rather than either
>   2006-10-20-23.59.59
>   2006-10-21-00.00.01
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.