Paul just add fractions of a day - segments from one of my Sps Offset = cast (ipExpiry_Sec as float) / (24 * 60 * 60); /* Fractions of Day */
update "Locks" set "End_Time" = current_timestamp + :Offset Date sent: Tue, 19 Apr 2005 16:11:26 +1200 From: Paul McKenzie <[EMAIL PROTECTED]> Organization: SMSS Ltd. To: Delphi List - Delphi <[email protected]> Subject: [DUG] Interbase dates Send reply to: NZ Borland Developers Group - Delphi List <[email protected]> <mailto:[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]> [ Double-click this line for list subscription options ] In Interbase 7.1 how do I add 1 to Now ? I want to be able to add 1 second to the current time... eg INSERT INTO MyTable(MyTimeStampField, MyVarCharField) VALUES ('NOW' + 1), 'Blah blah Blah'); COMMIT; -- Regards Paul McKenzie SMSS Ltd. Wellington New Zealand _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi Regards Rohit ====================================================================== CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand PH (649) 489-2280 FX (649) 489-2290 email [EMAIL PROTECTED] or [EMAIL PROTECTED] ====================================================================== _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
