Search code examples
postgresqlmigrationderby

What's the equivalent for PostgreSQL 'localtimestamp' in JavaDB - Derby?

Is there something simiar?

I have this definition

create table xyz ( 
    fecha_alta timestamp NOT NULL DEFAULT localtimestamp,
    ....
)

I tried to execute the same in Derby, but it complains with:

Error: Syntax error: Encountered "localtimestamp" at line 3, column 41.

What's the equivalent?

Solution

  • Derby doesn't have time zones in it's datatype TIMESTAMP and it doesn't have a "localtimestamp" either. Just use CURRENT_TIMESTAMP.

    http://db.apache.org/derby/docs/10.1/ref/