Greg's Cool [Insert Clever Name] of the Day

My technical, professional and sometimes personal blog.

Tuesday, May 04, 2004

RE: Separating Date and Time in T-SQL

RE: Separating Date and Time in T-SQL

Nice group of SQL Server 2K Date and Time functions...

Posted 5/04/2004 01:00:00 PM

No comments:

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Posts

Posts

Comments

Comments

About Me

Greg

View my complete profile

Connect...

gduncan411[at]hotmail[dot]com
Twitter
Facebook
FriendFeed
LinkedIn
GoodReads

What Do I Do (aka "About Me")
"About Me" from Coding4Fun
Blog Comment Policy
Blog Comment Moderation

Other stuff I'm doing...

Channel 9 Coding4Fun Blog
Channel 9 Coding4Fun Kinect Gallery
Channel 9 This Week on Channel 9
OData Primer
RadioTFS Podcast

Software Projects

Blogger Backup Utility
Microsoft Conference Resource List Maker
Scrum for Test System Quickboard
Vista Speech Saver Utility
WLW bLaugh Plugin
WLW Past As Plugin
WLW Picture Post Plugin
WLW Related Post Plugin
WLW Text Template Plugin
Zune Buzz Word Bingo

Code Samples

Linq to SQL Join Example (Getting Linq to use T-SQL IN)
VB.Net Binding List With Sorting Example

Resource Lists

A Feed You Should Read TOC
Scrum Resources
WiX Resources – Some help up the learning curve
OData Primer (Not mine, but one I'm active on)

Tag Cloud

.Net 3D 3DPrinting ADO AES AFeedYouShouldRead Agile ALM Amazon Amiga Analytics Android AppFabric arduino Art ASP.NET Audio AugmentedReality Azure BigData bing BloggerBackup Blogging Book BookReview BUILD C C# C++ Cache Car Career CastleProject Cat CellPhone cheatsheet Chrome ClickOnce Cloud CMS CodeCamp CodeContracts CodeGeneration ComputerHardware Contest Cordova CQRS CSR css CUIT CXXI Data DataMining DBA DDD DeepZoom DependencyInjection Deployment Design Development devops DirectX DNN DROOLS DSL DVCS ebook EDD EDI Education Elastic Energy EnterpriseLibrary EntityFramework Exchange Expression F# Firebird Firefox Flickr FreeImage gadget Game GData Geodata GIT GiveAway Giving Google Government GPS GregProject Hadoop Halo hardware HardwareReview HaswellReview HealthVault HoloLens HTML5 Humor IE IEExtension IfAllElseFails IIS IKVM ILMerge Image Infographic interview InversionOfControl IOT IronPython Ja.Net Java Javascript kindle Kinect Knockout LabManagement LASG Leadership Lego Life LightSwitch LINQ Linux LiveFX LosAngeles LOTRO Lucene Lync M machinelearning MAPI Mayhem MCE MediaCenter MEF meme Mesh Metro MicrosoftBand MicrosoftDynamics MicrosoftOffice MicrosoftOutlook Military MIX Mocking Mono Moodle MSBuild Music MVC MVP MVVM Netdunio NetMon NHibernate NLP node.js NoSQL NuGet OData ODF Office365 OGPL OneNote OpenGAX OpenGL OpenLiveWriter OpenXML OrchardCMS ORM OSS OutlookExpress Paint.Net PDC Personal Photosynth Physics podcast portable Poster PostSharp POTBS PowerShell Preparedness Presentation Prism PrivateCloud RadioTFS Razor ReactiveExtensions RegEx RemoteDesktop Reporting RIAServices Robotics RoboticsStudio RoundUp RTF Ruby SBS Science ScienceFiction Scratch Scrum ServiceBus SharePoint ShellExtension SideShow SignalR Silverlight SimiValley Singularity SmallBasic SocialMedia SOLID SPA Space SQLCE SQLite SQLServer SSDS Storyboard Surface SUSE SVG SVN Sync Framework sysinternals SystemAdministration SystemCenter T4 TeamBuild TeamFoundationServer TechEd Testing touchdevelop Training Treemap TypeScript UML UnitTesting UnityApplicationBlock Utility Velocity Ventura Veracity Veteran VirtualMachine Visio Vista VisualBasic VisualStudio WCF wearable Web X.X Webcast WebFeed WebMatrix WIF Wii Windows Windows10 Windows7 Windows8 Windows8.1 WindowsHomeServer WindowsLive WindowsLiveWriter WindowsMobile WindowsPhone WindowsServer WindowsSidebar WindowsStorageServer WindowsWorkflowFoundation(WF) Windsor WinForm WinJS WinPI WinRT WiX WMI WOPI WorkingAtMicrosoft WorldOrWarcraft WPD WPF Xamarin XAML XBox360 XboxOne XNA XPS XSL-FO XSLT zombie Zune

Blog Roll

castRoll (casts on my Zune)

Post Archive

Greg's bookshelf: read

If at First . . .

Soldier of the Legion

Dead Forever: Awakening

In Her Name: Final Battle

In Her Name: Empire

In Her Name: Confederation

Dinosaur Wars: Earthfall

The Honour of the Knights

East of the Sun, West of the Moon

Against the Tide (The Council Wars, #3)

Emerald Sea (The Council Wars, #2)

There Will Be Dragons

The Rational Guide to SQL Server 2005 Service Broker

Pro SQL Server 2008 Service Broker

Greg's favorite books »

}

Top 5 Popular Posts for the Last 30 Days

A story of Windows 7 and an empty All Programs (and how I fixed it)
Comment moderation now enabled...
GreatNews RSS Reader – One Week and Still Using It…
Free US ZIP Code Database as CSV
Interested in Hyper-V on Windows 8? Then you might be interested in the "Client Hyper-V Survival Guide"

Cool Friends (of the blog)

My articles have been featured in The Morning Brew - Daily .NET News and Views

Followers