June 25th, 2004, 07:41 AM
Sum = date + days. Is it possible?
Is it possible for me to make a sum in which I have a date and a integer (the number of days)? Something like:
newDate := dateOfBirth + 20;
So, FB would know if the month and year would change with the sum. If dateOfBirth = 20/06/2004 newDate would be 10/07/2004 or sth.
Is it possible to do something like this in FB?
Thank you so much
June 29th, 2004, 12:59 AM
Did you try it? If so, how?
These work fine for me:
select current_date, current_date + 10,
current_timestamp, current_timestamp + .5
current date + 10 days
current date/time + half a day
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle