Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Casting/converting date time stored as text

    Thanks Kristen

    First I used the statement to figure out the trouble makers and there were about 8 or so records. I was going to delete them but decided it wasn't...

    October 20, 2015 at 3:12 pm

    #1834508

  • RE: Casting/converting date time stored as text

    Interesting. I'm assuming those are as a result of some error in the format etc that it's not able to interpret? Relative to how many records I have that...

    October 19, 2015 at 8:27 pm

    #1834236

  • RE: Casting/converting date time stored as text

    Thanks Lynn. I don't fully follow what the code does, but here are the results. Can you fill me in? FYI there are 36,283,917 records in the db.

    Thanks

    date_time_txttestConvert

    NULLNULL

    NULLNULL

    2015-08-01 00:NULL

    NULLNULL

    NULLNULL

    NULLNULL

    NULLNULL

    NULLNULL

    2015NULL

    NULLNULL

    2015-08-0NULL

    NULLNULL

    NULLNULL

    1NULL

    0NULL

    NULLNULL

    13087NULL

    NULLNULL

    NULLNULL

    NULLNULL

    NULLNULL

    NULLNULL

    NULLNULL

    NULLNULL

    NULLNULL

    October 19, 2015 at 7:46 pm

    #1834234

Viewing 3 posts - 1 through 3 (of 3 total)