#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2012
    Posts
    1
    Rep Power
    0

    Conversion failed when converting date and/or time from character string


    I am getting this error

    "Conversion failed when converting date and/or time from character string"

    What does it mean?
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,027
    Rep Power
    4210
    it means your data has a value that isn't in the proper format to convert to datetime

    i'd be a bit more specific, but you didn't give us a lot to go on
    r937.com | rudy.ca
    please visit Simply SQL and buy my book
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2012
    Location
    Kansas City
    Posts
    13
    Rep Power
    0
    It depends, what does your select look like? What are you trying to cast it to? Show me an example of your data set.

IMN logo majestic logo threadwatch logo seochat tools logo