Inserting date to progress

[Strider]

Hi there,

im trying to insert a date into progress and im having no luck.
The date column is defined as 99/99/99

So my sql statement is as follows
INSERT INTO PUB.mytable VALUES ('17/01/05')

but its giving me errors

am i missing something here, should the date be surrounded in something other then apostraphes

 

[Strider]

ah.... hmmm, i can insert it as '01/17/05'

 

[cferriol]

So you got it.
Date format is MM/DD/YYYY.
If you want to go sure used format yyyy-mm-dd. It always works.

 

[Strider]

ya inside my application i have a function to convert all dates from dd/mm/yyyy to yyyy/mm/dd before the is added to the sql statement