Nicolas JOUANIN wrote:
> Hi,
>
> I'm new to SAPDB and I'm trying to migrate an Informix DB
> to SAPDB. No
> problem yet with SQL syntax conversion except the way to retreive the
> current date.
> With informix the keyword 'today' returns the current date.
> With postgres
> ,the equivalent is the function date('now'). What about SAPDB
> ? is there
> such a function (I guess yes) and where can I find
> documentation (where in
> SAPDB documentation) about that ?
Please check Reference manual --> Basic concepts --> Functions: Overview
to get an idea what FUNCTIONS we have. They are described in Functions
sorted according to their usage (string.., number, date...).
But you are looking for
Reference manual --> Basic concepts --> Specifying values --> value spec
and there date/time/timestamp and all the other 'special values' known by SAP DB.
May I ask you to check the chapter date_and_time_format (link is next to date)
to assure that you receive what you want.
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
