Thread: Database date

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    1
    Rep Power
    0

    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. #2
  3. Big Endian
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    May 2001
    Location
    Fly-over country
    Posts
    1,172
    Rep Power
    30
    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/article...,27004,00.html

IMN logo majestic logo threadwatch logo seochat tools logo