Post reply

Convert CHAR to DATETIME

  • August 6, 2012 at 4:15 am

    #1521939

    No, but 2012-07-29 00:05:28 does work.

  • August 6, 2012 at 4:27 am

    #1521946

    So the output of the below returns 0 | 1

    SELECT ISDATE('2012-07-29 00:05:28.819'), ISDATE('2012-07-29 00:05:28')

  • August 6, 2012 at 4:31 am

    #1521948

    No, 1|1 🙁

  • August 6, 2012 at 4:32 am

    #1521949

    Now this just gets stranger every post.

    Can you provide the CREATE TABLE script for the table in question?

  • August 6, 2012 at 4:36 am

    #1521950

    just to check...please run

    dbcc useroptions

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • August 6, 2012 at 5:11 am

    #1521961

    Create Table:

    USE [MSSQL_PerfmonCollector]

    GO

    /****** Object: Table [dbo].[CounterData] Script Date: 6/08/2012 13:09:51 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    SET ANSI_PADDING ON

    GO

    CREATE TABLE [dbo].[CounterData](

    [GUID] [uniqueidentifier] NOT NULL,

    [CounterID] [int] NOT NULL,

    [RecordIndex] [int] NOT NULL,

    [CounterDateTime] [char](24) NOT NULL,

    [CounterValue] [float] NOT NULL,

    [FirstValueA] [int] NULL,

    [FirstValueB] [int] NULL,

    [SecondValueA] [int] NULL,

    [SecondValueB] [int] NULL,

    [MultiCount] [int] NULL,

    PRIMARY KEY CLUSTERED

    (

    [GUID] ASC,

    [CounterID] ASC,

    [RecordIndex] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF

    GO

    dbcc useroptions output:

    Set Option Value

    textsize 2147483647

    language us_english

    dateformat mdy

    datefirst 7

    lock_timeout -1

    quoted_identifier SET

    arithabort SET

    ansi_null_dflt_on SET

    ansi_warnings SET

    ansi_padding SET

    ansi_nulls SET

    concat_null_yields_null SET

    isolation level read committed

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply