Re: changing dataformat from german to us-englisch

From: Jerry Pisk (jerryiii_at_hotmail.com)
Date: 03/24/04

  • Next message: Tammy: "RE: ADO, WinXP, SQL 2000: Not associated with a trusted SQL Server connection." 
    Date: Wed, 24 Mar 2004 11:04:29 -0800

    Don't parse the date as a string, pass it as a parameter of a command
    object. If you want to pass it as a string then you need to format it in the
    correct locale, not the one your users are running under.

    Jerry

    "Andreas" <abossong@z+remove+eb.de> wrote in message
    news:07573942-B777-4CB1-95E6-F064C2E2C189@microsoft.com...
    > Hi,
    >
    > we have a problem on some systems working with winnt4 sp6, mdac 2.5,
    access 2000 mdb, jet engine 4.0.
    >
    > If our (vb6-)programm wants to save a date in the accass-database
    (datatype in db is date and in the programm it is also date) and it is a
    date between the first and the 12th of a month, the format is us-englisch
    instead of german (german format: dd.mm.yyyy; for example the 12th of
    january is 12.01.2004 in german, in the database it changes to 01-12-2004).
    If it is a date after the 12th, the format is saved in german (for example
    the 13th of january will be safed right as 13.01.2004).
    > This problem comes on some pc, which are used with various software and
    not on a clean winnt4 installation. It semed to be that there are one or a
    few dll changed.
    >
    > Which are they? What else could be the reason for changing the format of
    the date?

  • Next message: Tammy: "RE: ADO, WinXP, SQL 2000: Not associated with a trusted SQL Server connection."

    Relevant Pages

    • Re: perl with mysql which takes a file as a input that contains the info to create the tables
      ... in the above text format u can find two tables one is Details> & the other ... strings, so you know that it will except a string. ... all you will need to do is shove the create table command in a single string ... Whatever command your string contains is then executed on your database so ...
      (perl.beginners)
    • Re: English-> German and GetNumberFormat()
      ... German uses the same windows character set and code page as the US version, ... Even Excel does use the "nice" format for displaying the numbers in the data cells, but as soon as you edit a cell, you get the "simple" number format in the edit field. ... that locale is not automatically set to the current user's locale. ...
      (microsoft.public.vc.mfc)
    • Re: English-> German and GetNumberFormat()
      ... I am German, so maybe I can help here a little bit. ... Even Excel does use the "nice" format for displaying the numbers in the data ... functions obey the number format set by the current locale. ... libraries (see my earlier reply where I said that it wasn't what he was doing, ...
      (microsoft.public.vc.mfc)
    • Re: How can I cause the datetime to be the name of the output file.....
      ... automatically create a file where the filename.zip would be a date/time ... If you can specify the file name when you invoke the command itself, ... you can build a command string using sprintf; ... generated them, you might use a format other than 020206143260.zip, ...
      (comp.lang.c)
    • Re: How can I cause the datetime to be the name of the output file.....
      ... automatically create a file where the filename.zip would be a date/time ... If you can specify the file name when you invoke the command itself, ... you can build a command string using sprintf; ... generated them, you might use a format other than 020206143260.zip, ...
      (comp.lang.c)