Click 'Connect with Facebook' to join NetworkedBlogs. NetworkedBlogs is a community of bloggers and blog lovers. Join the fun, add your blog, and connect with others who read and write about subjects you like.
SQL Function to Concatenate DateTime
Today I bring to you a useful SQL function to get a string like YYYYMMDDHHMMSS (example for 30-10-2009 20:01:01 will be 20091030200101).
Use YourDatabase
Create function [dbo].[F_Datetime]()
returns varchar(50)
as
begin
d
Not enough data.
Calculated for blogs with 20+ followers.
- Brent Ozar - SQL Server DBA
sqlserver, sql, database
- Left Outer Join
SQL, GEEK, TECH
- Digitizor
linux, windows, web
- Bugsplat
software development, SQL, .NET
- James's Digital Plexus: A Computing Biography
Windows, Software & Hardware, IT News
Questions? contact: networkedblogs@ninua.com
Copyright (C) 2008, Ninua, Inc.