Results 1 to 2 of 2

Thread: Akhilesh

  1. #1
    DateMan Guest

    Default Akhilesh

    So, <BR>select mydate, myname from tbl where mydate = convert(varchar(10), dateadd(day,-1, getdate()), 101) <BR><BR>A)will give me for the previous day? <BR>B)with out the mins:secs? <BR>C)if i want previous month use convert(varchar(10), dateadd(MONTH, -1, getdate()), 101)? <BR><BR>Thank you so much for your help today, it has really helped me. I will strive to contribute to others as you have to me. <BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Sorry i did not realise they were questions...

    a yes<BR>b yes<BR>c yes<BR><BR>Glad to help...Isnt this what we are all here for

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts