|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
July 23rd, 2003, 10:14 AM
|
|||
|
|||
|
Database date
I use Firebird1.0 and Dialect1 and I'm using the following SQL statement to get system´s date:
select current_timestamp from rdb$database It does work in some machines, but it doesn't in others. The instalation procedure was the same in all machines but I receive the error "column unknown (current_timestamp)" in some of them. Can you help me? Thank you! Carolina
|
|
#2
July 23rd, 2003, 11:19 PM
|
||||
|
||||
|
I always use Dialect 3 so I've never encountered your problem. Take a look at this document on Borland's website and search for the phrase "column unknown". This section discusses the use of Date and Time datatypes in Dialect 1.
I don't know if this will help you solve your problem, but hopefully it might give you a clue to its source. http://community.borland.com/articl...0,27004,00.html
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Database date |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
