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 |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2004-06-25 : 15:12:52
|
| Damn,JB was on the Today show and I forgot to set the VCR...anyone get it on tape?Brett8-) |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-06-25 : 15:24:51
|
On my server...select datediff(mi, getdate(), dbo.weekend(getdate()))/60.00 as HourstoMargarittavilleHourstoMargarittaville ---------------------- 1.633333 |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-25 : 15:30:47
|
| Special one for todayselect (datediff(mi, getdate(), dbo.weekend(getdate()))/60.00)-1 as HourstoMargarittavilleBrett8-) |
|
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-06-25 : 15:33:02
|
Nice!!!!  Not me though.  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-25 : 15:57:52
|
| Brett, I worry about you ... I mean, I'm surprised you don't find the need to be at meetings in the UK on Fridays to get to HourstoMargarittaville 5 or 6 hours earlier! - of course you could go even further East ... perhaps just managing a server over here to get the GetDate() function into the right timezone would do?!.. however, I have some family advice for you. My faterh-in-law was a doctor, now retired. And he says "The only thing wrong with alcohol is worrying about it", so now I've stopped worrying abou it, and I'm just fine!Kristen |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-06-25 : 16:09:12
|
Everyone's got to have something to look forward to...Let the man have his Margaritta's in peace...I'll keep my Crown & Coke  Corey |
|
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-06-25 : 16:22:03
|
 'nough said. |
|
|
|
|
|
|
Buffet Today