Subject | Date question. |
---|---|
Author | Rosivaldo Azevedo Ramalho |
Post date | 2004-04-27T19:16:20Z |
Hello there, in a MySQL database i could use:
mysql> SELECT something FROM tbl_name WHERE TO_DAYS(NOW()) -
TO_DAYS(date_col) <= 30;
I couldn't find a way to do the same with Firebird, do i need to make a
UDF or something like this? I'm new using it so i'm having troubles,
hope you can help me.
Thanks
--
Rosivaldo Azevedo Ramalho
rosivaldo@...
+55 83 8803 0969
mysql> SELECT something FROM tbl_name WHERE TO_DAYS(NOW()) -
TO_DAYS(date_col) <= 30;
I couldn't find a way to do the same with Firebird, do i need to make a
UDF or something like this? I'm new using it so i'm having troubles,
hope you can help me.
Thanks
--
Rosivaldo Azevedo Ramalho
rosivaldo@...
+55 83 8803 0969