You can also use the date() and time() SQL function;
select date(start_time) pull out just the date part; select
time(start_time) pulls out just the time part.
-----Original Message-----
From: Maurice van 't Loo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 3:20 PM
To: [EMAIL PROTECTED]
Subject: Re: Select Question
Try:
select * from tables
select * from enumtypes
select * from columns
This will give you all the table info.
To get rid of the date from the starttime depends on the way you use your
output. With AIX scripts you can use jl. cut (man cut) If you use ODBC, you
can use the tools that the DB application deliver.
Maurice
----- Original Message -----
From: "Anderson, Michael - HMIS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 9:10 PM
Subject: Select Question
> Is there somewhere that I can find the sql names of the fields
that
> are available in the different tables. For example I am trying
> to query the event table for the start time, completed time, and the
> status for specific nodes. I figured out the start time and status
> but I am having trouble with the completed time. I guess what I am
> trying to say is, how can I see what info is in the table available
> to me. Also is there a way to get rid of the date from the start
time.
>
>
> Thanks
> Mike Anderson
> [EMAIL PROTECTED]
>
>
> CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
> is for the sole use of the intended recipient(s) and may contain
> confidential
> and privileged information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> contact the sender by reply e-mail and destroy all copies of the original
> message.
>
