You may want to look here: http://www.sapdb.org/7.4/htmhelp/15/1a2bb4b44d11d2a97100a0c9449261/content.htm , and use the 'keyword' DATE to get the current date.
Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Nicolas JOUANIN [mailto:[EMAIL PROTECTED] > Sent: Friday, July 11, 2003 1:49 PM > To: [EMAIL PROTECTED] > Subject: New to SAPDB > > > 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 ? > > Thx, > > Nicolas. > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
