Date from DateTime field

I want to use sql to get the date from a datetime field. I have written
Select Date(B.EventDate) From HistoricalEvents as B; but it does not
work. What is the correct syntax?

<< What is the correct syntax? >>

select cast(B.EventDate as date) EventDate
from HistoricalEvents B

Ole Willy Tuv

Mark Clark wrote:
> I want to use sql to get the date from a datetime field. I have written
> Select Date(B.EventDate) From HistoricalEvents as B; but it does not
> work. What is the correct syntax?
>

Hmm round() is supposed to take away the time portion of a datetime
and return just the date but seems to return a numeric value instead.

SELECT ROUND(B.EventDate) from HistoricalEvents B;

Should work to chop off the time portion of a date but currently
doesn't.

Brian Evans

Brian Evans wrote:

> Mark Clark wrote:
>
>> I want to use sql to get the date from a datetime field. I have
>> written Select Date(B.EventDate) From HistoricalEvents as B; but it
>> does not work. What is the correct syntax?
>>
>
> Hmm round() is supposed to take away the time portion of a datetime
> and return just the date but seems to return a numeric value instead.
>
> SELECT ROUND(B.EventDate) from HistoricalEvents B;
>
> Should work to chop off the time portion of a date but currently
> doesn't.
>
> Brian Evans

Opps ROUND is bad to use since it rounds up sometimes.
I usually use TRUNC() in oracle which NexusDB doesn't
have. In Nexus use FLOOR() which in fact does return
a date when the arguement is a date.

SELECT FLOOR(B.EventDate) from HistoricalEvents B;

Brian Evans