Post reply

DATETIME

  • September 18, 2014 at 1:28 pm

    #290090

    I know I am missing something pretty simple.. But cant figure out.

    I need to print Not assigned (NA) whereever there is NULL

    If its a date and is NULL then NA else show DAtetime .

    I can convert it into Date but the time messes up. Also , I don't want it show oo:oo:oo as time but the actual time.

    This is what I have :

    ISNULL(CONVERT(Varchar(10),Start_Time,121),'Unknown')Start_Time

  • September 18, 2014 at 1:33 pm

    #1746528

    Does increasing the length of your varchar to 19 solves the problem?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • September 18, 2014 at 1:36 pm

    #1746529

    Oh Yes. Why didn't i see that ..

    Thanks a ton

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

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