At 11:56 AM 3/12/2008, you wrote:

>I don't quite understand what u mean. Anyway I attached a snapshot of it..

The list doesn't take attachments.

Please trim your postings.

>--- On Tue, 12/2/08, Thomas Steinmaurer <ts@...> wrote:
>
>> I try the following statement but the time is still appear when I run it.
>>
>> select cast(Edit_Time as date) from ML_FG_EFFicientD
>>
>> Could it due to different IB Version? I am using IB Manager 3.8.0.1.
>
>Perhaps it is a date/time format issue in IB Manager. Is the shown time
>always 00:00:00?

You wrote:

>I don't quite understand what u mean.

Do you understand that visual tools such as IB Manager that you are using apply a "picture" to date and time types? The actual *data* are just numbers.

-- For TIMESTAMP type, there are two numbers: one number that records the number of days since "date zero" + another number that records the number of milliseconds (or thousandths of seconds, depending on config.) since midnight.
-- For DATE type, there is just the one number that records the number of days since "date zero"
-- For TIME type, there is just the one number that records the number of milliseconds (or thousandths of seconds, depending on config.) since midnight.

So, what Thomas means is, does IB Manager always display DATE type data as though it were TIMESTAMP data, i.e., displaying a date with 00:00:00 in the time?

You could check this by using IB Manager to view a table that is storing a DATE column...

^heLen