<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Scripts with tag
DateTime
Search for
any
content tagged
datetime
Add a script
Items 1 to 10 of 10
Converting to datetime a char field with several possible date formats
Converting to datetime a char field having several possible date formats
Read more...
By
Federico Iori
2013/02/21
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,249 reads
TSQL fast unix timestamp conversion
How to convert Unix timestamp into datetime taking into account also summer or winter time
Read more...
By
Federico Iori
2011/12/02
|
Source:
SQLServerCentral.com
|
Category:
timestamp
Rating:
|
Discuss
|
Briefcase
|
418 reads
How long has passed since SQL Server service started?
Days, hours and minutes since SQL Server service was started
Read more...
By
Lars Søe Mikkelsen
2010/11/05
|
Source:
SQLServerCentral.com
|
Category:
getdate()
Rating:
|
Discuss
|
Briefcase
|
2,200 reads
datetime precision
Accuracy and precision go hand-in-hand. This script helps trim date values to whatever size is stored in a table's column.
Read more...
By
William Talada
2010/01/20
|
Source:
SQLServerCentral.com
|
Category:
datetime
Rating:
|
Discuss
|
Briefcase
|
1,056 reads
What were the dates of all the Fridays in this quarter?
This script displays list of all dates of all Fridays of this quarter.
Read more...
By
Ashka Modi
2009/08/25
|
Source:
SQLServerCentral.com
|
Category:
datetime
Rating:
|
Discuss
|
Briefcase
|
1,011 reads
GetDateTime Function
This function gets a variable string and converts to DateTime format 'YYYY-MM-DD HH:MM' Ex. '200907111405' Convert to '2009-07-11 14:05:00'
Read more...
By
Luis Atondo
2009/07/30
|
Source:
SQLServerCentral.com
|
Category:
convert
Rating:
|
Discuss
|
Briefcase
|
995 reads
GetDateTimeString Function
This function gets a variable and converts to DateTime format string 'YYYYMMDDHHMM' Ex. '07/11/2009 2:05 PM' Convert to '200907111405'
Read more...
By
Luis Atondo
2009/07/31
|
Source:
SQLServerCentral.com
|
Category:
datetime
Rating:
|
Discuss
|
Briefcase
|
866 reads
Functions for using the keys from the Date and Time Dimensions
Three functions for obtaining the date and time dimension keys with a date or the date from the keys
Read more...
By
Joshua A. Walker
2011/05/03
|
Source:
SQLServerCentral.com
|
Category:
data warehousing
Rating:
|
Discuss
|
Briefcase
|
3,797 reads
Date and Time dimension creation and population T-SQL
Dim_Date and Dim_Time. Date and Time dimensions. Creation, population with holidays, indexing and use script.
Read more...
By
Joshua A. Walker
2011/03/08
|
Source:
SQLServerCentral.com
|
Category:
data warehousing
Rating:
|
Discuss
|
Briefcase
|
19,980 reads
Get DATE part of the DATETIME
A quick and elegant way to obtain date part of the datetime values
Read more...
By
Jano Petras
2011/06/14
|
Source:
SQLServerCentral.com
|
Category:
datetime
Rating:
|
Discuss
|
Briefcase
|
5,692 reads
Items 1 to 10 of 10
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
