<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>
Content with tag
DateTime
Items 1 to 20 of 22
Next 20 >>
DATETIME - 4
Read more...
By
bitbucket
2013/03/18
|
Category:
datetime
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,754 reads
DATETIME - 3
Read more...
By
bitbucket
2013/03/11
|
Category:
datetime
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,731 reads
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,245 reads
DATETIME 2
Read more...
By
bitbucket
2012/08/02
|
Category:
datetime
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,612 reads
DATETIME 1
Read more...
By
bitbucket
2011/12/07
|
Category:
datetime
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,210 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
|
417 reads
DateTime Comparison
Read more...
By
jkelly
2011/11/28
|
Category:
datetime
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,623 reads
Use of DATETIME and BETWEEN - Part 2
Read more...
By
Dwayne Dibley
2011/11/18
|
Category:
datetime
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,723 reads
Use of BETWEEN and DATETIME
Read more...
By
Dwayne Dibley
2011/09/27
|
Category:
datetime
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,650 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,691 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,796 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,975 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,199 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,199 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
T-SQL
Read more...
By
bitbucket
2009/11/17
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,474 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
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
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
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,796 reads
Items 1 to 20 of 22
Next 20 >>
Tags
t-sql
(9)
date manipulation
(7)
convert
(3)
cast
(2)
data warehousing
(2)
datawarehouse
(2)
dimensions
(2)
function
(2)
between
(1)
case
(1)
converter
(1)
datediff
(1)
datepart
(1)
getdate()
(1)
len()
(1)
precision
(1)
substring
(1)
summer time
(1)
timestamp
(1)
unix
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
