|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 19th, 2005, 10:17 AM
|
|||
|
|||
|
getting current date with select?
I know that it is possible to get current date/time in triggers using "now", "today", however - does some tricky way exist how to get current date using select ( e.g. select ... from RDB$DATABASE ), I mean - using only SQL (apparently - one can write UDF, however - the better solution in my case could be without the definition of new UDFs).
Thanks in advance.
|
|
#2
July 19th, 2005, 10:53 AM
|
||||
|
||||
|
You are looking for CURRENT_TIMESTAMP (or CURRENT_DATE or CURRENT_TIME).
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > getting current date with select? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
