Hi Guys,

Simple one for you EDB users...

The following ElevateDB SQL statement wont work like it does in DBISAM,
it doesn't recognise the date format and is requiring a TIMESTAMP or
NULL... What's should I be doing different in ElevateDB?

INSERT INTO guest (res_num, ar_time, dep_time, roomcat, status)
VALUES('2020',
'2008-07-25 11:00 PM',
'2008-07-29 11:00 PM',
1,1)

CHeers!

All OK, I just found the TIMESTAMP keyword i.e

INSERT INTO guest (res_num, ar_time, dep_time, roomcat, status)
VALUES('2020',
TIMESTAMP '2008-07-25 11:00 PM',
TIMESTAMP'2008-07-29 11:00 PM',
1,1)

Phil


If you like that one wait until you discover intervals <vbg>

Roy Lambert