oracle / quicksql

A library for generating DDL SQL and entity-relationship-diagrams from Quick SQL code
Universal Permissive License v1.0
53 stars 11 forks source link

'N/A' column value for TIMESTAMP column type #29

Closed vadim-tropashko closed 9 months ago

vadim-tropashko commented 11 months ago

Input:

employees /insert 1
      date hired

#settings={ date:timestamp}

Output:

create table employees (
    id            number generated by default on null as identity
                  constraint employees_id_pk primary key,
    date_hired    timestamp
);

-- load data

insert into employees (
    id,
    date_hired
) values (
    1,
    'N/A'
);

commit;
vadim-tropashko commented 9 months ago

1.2.1