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
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,781 reads
DATETIME - 3
Read more...
By
bitbucket
2013/03/11
|
Category:
datetime
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,751 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,285 reads
DATETIME 2
Read more...
By
bitbucket
2012/08/02
|
Category:
datetime
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,617 reads
DATETIME 1
Read more...
By
bitbucket
2011/12/07
|
Category:
datetime
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,213 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
DateTime Comparison
Read more...
By
jkelly
2011/11/28
|
Category:
datetime
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,626 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,742 reads
Use of BETWEEN and DATETIME
Read more...
By
Dwayne Dibley
2011/09/27
|
Category:
datetime
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,652 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,697 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,818 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
|
20,065 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,204 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,204 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,058 reads
T-SQL
Read more...
By
bitbucket
2009/11/17
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,478 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,012 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
|
869 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
|
998 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,818 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.