Options

Data formatting problems

dhanjeldhanjel Posts: 4
edited May 10, 2010 1:16PM in SQL Packager Previous Versions
In the database we have the data type DateTime on a field and it is presented in the database as 2010-01-25 10:12:11.234

Some combinations of collations and/or locale settings on computers requires that there are no lines in the date-strings.

Is it possible to remove the lines between YYYY-MM-DD in the script generated from sql packager?
· Share on Twitter

Comments

  • Options
    Linda HawksworthLinda Hawksworth Posts: 194
    I have logged your request for SQL Packager to remove the dashes from the date format in the generated script (SPA-538). It will be considered for a future release of SQL Packager although we have no timescales for this at present.
    · Share on Twitter
  • Options
    dhanjeldhanjel Posts: 4
    It's been a couple of months now with no more information on this,
    is there any known workaround for this problem?
    We've tried to alter the locale settings with no luck.
    · Share on Twitter
  • Options
    Linda HawksworthLinda Hawksworth Posts: 194
    I spoke to one of the development team about this. He asked if the iso format works, ie ISO8601 yyyy-mm-ddThh:mi:ss.mmm

    Alternatively, could you tell us what collations/locales don't work?
    · Share on Twitter
  • Options
    dhanjeldhanjel Posts: 4
    Our export date format looks like your example above (from a swedish 2008 db) with "yyyy-mm-dd" but a French SQL express 2008 (French_CI_AS) does not accept this format when running the EXE from SQL packager.
    However, if we generate the scripts, and then change the dates manually to yyyymmdd it works (when running the scripts manually).
    The problem is that we generate an exe file with your tool and we have no way to change the dateformat to yyymmdd.

    Is there any known workaround ?

    Best regards
    Daniel
    · Share on Twitter
  • Options
    Chris AucklandChris Auckland Posts: 769
    Just to let you know that we now have a patch avaliable that should resolve the above issue.

    For more information and a download link, see

    http://www.red-gate.com/messageboard/vi ... hp?p=35709
    Chris
    · Share on Twitter
Sign In or Register to comment.