CAST (value AS TIMESTAMP) or CAST (value AS DATE) or CAST(value AS TIME) and same patter apply for any time.

Like Oracle Interbase/Firebird will automatically convert a string representation of a date/datetime to a date, however, you may CAST the string value to a date/date time explicitly by:

cast(‘2/1/2001′ as date)
cast(’01-FEB-2001’ to date)
cast(NULL as date)
cast(‘TODAY’ | ‘YESTERDAY’ | ‘TOMMOROW’ | ‘NOW’ as date)
you also may add the time component
cast(’01-FEB-2001:23:59:59′ to date)

var_Time = CAST(in_Date AS TIME);


2 comentários »

  1. phyto sc said

    I have been exploring for a little bit for
    any high quality articles or blog posts on this kind of house .
    Exploring in Yahoo I eventually stumbled upon this website.

    Studying this info So i am happy to convey that I’ve a very good
    uncanny feeling I came upon exactly what I needed. I most definitely will make certain to don?t
    disregard this web site and provides it a glance regularly.

  2. Piece of writing writing is also a excitement, if you be acquainted with then you can write if
    not it is complicated to write.

RSS feed for comments on this post · TrackBack URI

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da

Está a comentar usando a sua conta Terminar Sessão /  Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão /  Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão /  Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão /  Alterar )


Connecting to %s

%d bloggers like this: