Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Location
    New York
    Posts
    248

    Unanswered: convert date during unload

    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

  2. #2
    Join Date
    Jun 2009
    Location
    Lisboa, Portugal
    Posts
    78
    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.
    LS

  3. #3
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    Thank you Luis, I know it had to be something simple ))

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •