NEED TO CHANGE DATE CYCLE EVALUATION

• Question

• 

  

  0

  Sign in to vote

  hi friends, I am having a problem with datetime datatype of sqlserver. for a specific database (let's assume database name ABC)
  i want my date cycle to start from 6:00 Am rather than 00:00AM.
  i.e. i want my date to start from 6:00 AM from tomorning to 5:59 AM of next date.
  e.g if todat is 22 APR 2009 then my previous date was
  22 APR 2009 5:59 AM and todays date will after 1 minute is 22 APR 2009 6:00 AM.
  So anyhow can i change the date evaluation cycle of the database.
  
  please geeks help me out.
  
  Thanks a lot in advance...
  
  Bhagyesh Joshi
  (+919714775899)

  ---

  destiny

  Tuesday, April 21, 2009 4:51 AM