SQL

• vjagades

  Newbie

  Points: 3

  More actions

  September 24, 2014 at 3:10 am

  #397392

  Hi All,

  Im developing web application. for that application having one table,

  Table Name : Car_Details

  Field Name : departure_Date Frequency,

  For My doubt,

  If frequency is daily departure_Date is automatically is change to next day at the time of night 12.

  likewise weekly...

  Thanks and Regards,

  Jagadeesh

• Neil Burton

  SSC-Insane

  Points: 23003

  More actions

  September 24, 2014 at 3:17 am

  #1747748

  Hi Jagadeesh,

  welcome to the forum. I'm not sure what your question is there. If you read the article in my signature it will make it much easier to get help.

  Neil

  ---

  On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
  —Charles Babbage, Passages from the Life of a Philosopher

  How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  September 24, 2014 at 8:45 am

  #1747863

  Why do you want to change a value daily?

  If you want to keep track of the departures, you need one row per departure. If you don't care about history on that table, you could use time data type instead of a datetime data type.

  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