Re: UTC dates in SQL 2000

From: Andrew Robinson (chunkydrew33136_at_hotmail.com)
Date: 07/02/04

  • Next message: whornak: "Invalid Authorization Specification" 
    Date: Fri, 2 Jul 2004 08:48:55 -0700

    This db provides dates, which the developer (CISCO)
    identifies as UTC, in the format 99999. Using this, 38169
    converts to 7/2/04. I can use the
    getutcdate() function to return the datetime for the
    current UTC, or I can CONVERT(int, datetime) to convert a
    datetime into UTC, but neither will work in an ActiveX
    script. Are we talking about the same thing, or is Cisco
    using UTC in a different way?

    >-----Original Message-----
    >There is no built in transform type of UTC --> Datetime
    so you will have to
    >roll your own so
    >
    >This is UTC format YYMMDDHHMMZ
    >
    >I would parse this in a Active Script transform
    extracting the relevant
    >parts and rebuilding it into a suitable string for a
    datatime field in SQL
    >Server.
    >
    >We do this partially here
    >
    >Formatting Character Data into Datetime fields
    >(http://www.sqldts.com/default.aspx?249)
    >
    >--
    >
    >Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
    >www.SQLDTS.com - The site for all your DTS needs.
    >I support PASS - the definitive, global community
    >for SQL Server professionals - http://www.sqlpass.org
    >"Andrew Robinson" <Andrew
    Robinson@discussions.microsoft.com> wrote in
    >message news:AFE6DC10-51CA-41D8-A499-
    610281D865A5@microsoft.com...
    >> I need to create a DTS package to transfer data from
    SQL to a text file.
    >My problem is, all the datetime fields in the db are in
    UTC format. Is there
    >is function I can use to convert these to datetime
    format as part of the
    >transformation?
    >
    >
    >.
    >

  • Next message: whornak: "Invalid Authorization Specification"

    Relevant Pages

    • Re: [PHP] Using DateTimeZone
      ... and switching to using the internal DateTime functions. ... Information is stored in the databases UTC normalized, ... DATE_ATOM is a locale independent format AFAICT. ...
      (php.general)
    • Re: [PHP] Using DateTimeZone
      ... Information is stored in the databases UTC normalized, ... display it with the users timezone offset. ... To format dates in other languages, you should use the setlocaleand strftimefunctions instead of date. ... Along with the problem that DateTime does not handle genealogical dates either - which ADOdb::Date does. ...
      (php.general)
    • Re: script to check change in groups
      ... Dim strLastDateFile, objFSO, objDateFile ... Const ForReading = 1 ... ' Specify file where last change date (in UTC) is saved. ... The format of the whenChanged attribute is generalizedTime, ...
      (microsoft.public.windows.server.scripting)
    • Re: UTC dates in SQL 2000
      ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > This db provides dates, which the developer > identifies as UTC, in the format 99999. ... > getutcdatefunction to return the datetime for the> current UTC, or I can CONVERTto convert a> datetime into UTC, but neither will work in an ActiveX> script. ...
      (microsoft.public.sqlserver.dts)
    • Re: Date and Time
      ... Which is the "user client zone" value, ... since epoch, several time formats, and one of the standard UTC formats. ... The time format you are using determines what would be the best approach to ... I know this can't be done on the server side. ...
      (comp.lang.javascript)