Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bhagyeshworld
Starting Member
1 Post |
 Posted - 2009-04-21 : 00:40:08
|
| 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 was22 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) |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2009-04-22 : 00:06:28
|
| Hello Bhagyesh,Can you please give us more details? Your posting is a bit confusing (at least to me). Are you perhaps trying to address some timezone issues? Or is this some type of scheduling application maybe? I think some additional details around the core problem youre addressing would clear things up.We want to help :) |
 |
|
|
|
|
|
DATABASE DATETIME ISSUE