Skip to main content

imransi

Member since Jun 4, 2010

Recent Blog Comments By imransi

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Jun 7, 2010 at 4:06 PM

    No, single quotes will not work. the error is from line 1. following is what i am trying to do. Example: Column1 Column2 2009-01-08 19:42:00.000 2009-08-01 19:42:00.000 Also, I don't know the code to update just the month and also just the day with in a datetime column. Please... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Jun 4, 2010 at 12:25 PM

    I need a lill help from you all smartys! I am working on an update of a datetime field and receiving the following error. Query: Update tbl SET Month(column 1) = Month(Column 2), Day(column 1) = Day(column 2) WHERE Month(column 1) = Day(column 2) and Day(column 1) = Month(column 2) and id in (111... read more »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
— Ben Nadel