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.

 All Forums
 Site Related Forums
 The Yak Corral
 12:34:56 07/08/09

Author  Topic 

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2009-07-08 : 23:23:25
special time today, won't occur again for many years!

unless you put the day before the month. then you have another month to prepare.




elsasoft.org

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-07-09 : 00:48:58
only for those MM/DD/YYYY. It will be Aug 7, 2009 for us with DD/MM/YYYY


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-07-09 : 02:45:53
What about us YMD people?

09-08-07 06:05:04



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2009-07-09 : 03:06:33
again, you have a month to prepare. dream big. :)


elsasoft.org
Go to Top of Page

pootle_flump

1064 Posts

Posted - 2009-07-09 : 03:50:41
Jesse - you love these things don't you? Do you have a whole set of Outlook reminders set for the next 15 years?

BTW - ta for the heads up. I picked up on this too late had I displayed my dates in a nonsensical format, but fortunately I'm from the UK and we do things properly over here
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2009-07-09 : 04:43:11
quote:
Originally posted by pootle_flump

Jesse - you love these things don't you? Do you have a whole set of Outlook reminders set for the next 15 years?

BTW - ta for the heads up. I picked up on this too late had I displayed my dates in a nonsensical format, but fortunately I'm from the UK and we do things properly over here



We do? Since when? -- crap I'm screwed!


Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page

waterduck
Aged Yak Warrior

982 Posts

Posted - 2009-07-09 : 05:40:32
Malaysia clocks are...dunno how many types..so not sure whats the time now...
BETWEEN(DATEADD(MINUTE,+3,12:34:56 07/08/09),DATEADD(MINUTE,-3,12:34:56 07/08/09))
Different ppl different watch with different time...even computer time with punch card time are differnt >"<

Hope can help...but advise to wait pros with confirmation...
Go to Top of Page
   

- Advertisement -