Guys I need to create a data dump of my database so I can load it into SQL Server, in order for me to load it in
SQL Server the date format need's to be "yyyy-mm-dd" is there a way to do this on the unload ? dbexport does not have that option

Any help is appreciated, thanks in advance

Hi artemka,

When you do unload to export the data of a table, the system reads your user profile, and uses an environment variable called DBDATE. In that case if you have it like DBDATE=Y4MD- when you export your data from date type comes yyyy-mm-dd, and you dont need nothing for it.

Thank you Luis, I know it had to be something simple ))