>Hi there
>
>ADSM 3.1.2.50 on AIX returns an incorrect timestamp using the select command.
>Can anyone verify if this is corrected in level 54 or 55 ?
>
>Regards, Carsten Moldrup
>
>tsm: GFADSM>select count(*), current timestamp from nodes
>
> Unnamed[1]             Unnamed[2]
>-----------     ------------------
>         21             2000-04-14
>                   16:22:03.000000
>
>tsm: GFADSM>show time
>
>Current Date and Time on the Server
>----------------------------------------
>03/14/2000 16:22:29
>UTC (GMT) Date/Time is: 03/14/00 15:22:29
>Last Noted Date/Time is: 03/14/00 16:16:39
>
>tsm: GFADSM>

Mine works (AIX 4.3.1, ADSM 3.1.2.55)

adsm> select count(*), current timestamp from nodes

 Unnamed[1]             Unnamed[2]
-----------     ------------------
          1             2000-03-14
          1             2000-03-14
                   13:33:10.000000

adsm> sho time

Current Date and Time on the Server
----------------------------------------
03/14/00   13:33:51
03/14/00   13:33:51
UTC (GMT) Date/Time is: 03/14/00 18:33:51
Last Noted Date/Time is: 03/14/00 12:39:34
--
Richard
Richard