Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: atetime
108 results found
Convert 24 Hour Time with SSIS Derived Column
If you want to convert the time part of a DateTime data type into common non-military time display of hour and minute with AM or PM with no leading zeros, you can use this expression in a Derived Column. It uses the DATEPART Function to get the appropriat
Author:
timmurphy
Date: 8/12/2011 Section:
Blog
tags :
derived column
,
expression
,
Time
SQL Server 2012 TSQL DateTime Functions Part 3
In this third blog post we will cover the new DateTime functions available in SQL 2012. If you have read my previous 2 postings on this subject you probably have noticed only 2 -3 function per category. Well in this posting this changes where we will be c
Author:
ChrisAlbrektson
Date: 3/26/2012 Section:
Blog
tags :
SQL Server 2012 Functions
,
TSQL Functions
Dealing with time duplicates
I know I'm "late to the party" with this reply - and you may have already found a solution to this with DustinRyan's help. But if you haven't yet - a few things come to mind when I read your post. According to http://msdn.microsoft.com/en-us/library/ms187
Author:
KeithHyer
Date: 7/21/2011 Section:
Forum
tags :
conversion
,
datetime
,
lookup
,
redirect rows
,
smalldatetime
Function to calculate end of month - SQL Server 2012 - new function EOMonth
As in my previous blog posts, I've been posting some new features in SQL Server 2012. In today's post, I would like to show you a new T-SQL function wich will lead you to solve a daily problem. So far, when you needed to get the last day from current mont
Author:
marcoadf
Date: 4/2/2012 Section:
Blog
tags :
end of month
,
eomonth
,
function
,
new features
,
new functions
Dealing with time duplicates
You could try something like this. First, let's set up a test table to look like the top 2 datetime values in your staging table: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Datalog_stage]') AND type in (N'U')) DROP TABLE [db
Author:
KeithHyer
Date: 7/22/2011 Section:
Forum
tags :
duplicates
,
ranking
,
ssis
Some Statements To Return Today's Date
Any of the following Statements will give your current Date and Time: SYSDATETIME() SYSDATETIMEOFFSET() SYSUTCDATETIME() GETDATE() GETUTCDATE(); CURRENT_TIMESTAMP
Author:
manfredtabe
Date: 10/25/2011 Section:
Blog
tags :
sql_princezz
,
Talla-ah Fusi
Learning to use Derived Columns Transform to convert String data type to “D
atetime
” type
In loading “.csv” files to a SQL Server 2008 database, I have encountered several data type issues, especially regarding “Datetime” for a “Modified Date” column on my tables. Here is my ordeal: After adding my Flat File
Author:
nube07
Date: 3/19/2012 Section:
Blog
tags :
atetime
,
convert
,
substring
Reference the Previous Record in a Data Set with SQL Server 2000
A couple blog posts ago , I discussed using a Common Table Expression (CTE) and the ROW_NUMBER() function to create a field in a data set the retrieves a field in the previous row. But since CTE's and the ROW_NUMBER() function aren't available in SQL Serv
Author:
DustinRyan
Date: 7/14/2010 Section:
Blog
tags :
look up last row
,
reference previous record
,
table variable
Dealing with time duplicates
I have an SSIS package that inserts data into a database, but only rows that have a TempDateTime every 30 minutes in the source file. I cannot modify the source file, which records data every minute. When I pull the data, it has data that is already in th
Author:
shauntih
Date: 7/19/2011 Section:
Forum
Use Date Picker Control with MDX Based Reports
If you've done a couple cube based reports, you've run into the issue of the dates being in string format. Because the dates are strings inside your cube, you can't use the neat little date picker control reporting services gives you for datetime paramete
Author:
DustinRyan
Date: 1/15/2010 Section:
Blog
tags :
calendar control in MDX report
,
date picker in MDX report
,
SSAS
,
MDX
Chart synced with other data
SSRS 2008 r2 I have 2 datasources, 2 datasets and 2 objects on the report. 1st object is a chart, 2nd object is a tablix Chart gets data from 1st dataset, x axis is time Tablix has some other data from 2nd dataset that I want to filter dependent on time p
Author:
syale
Date: 4/9/2012 Section:
Forum
tags :
parameters
,
syncs
,
tablix
Embedding comments or tags within report for admins?
Decoy, You have many options here. I personally would just put the execution date and timestamp on the report. Then what you could do is have them email that the report to you. You could use that datetime timestamp to query the report execution log for th
Author:
briankmcdonald
Date: 4/25/2011 Section:
Forum
tags :
brian k mcdonald
,
Reporting Services
,
sqlbigeek
,
SSRS
Aging Report For Trouble Tickets
While you would handle this differently in an ETL data flow, here is a SQL function that would do what you're after for hours and minutes. IF EXISTS( SELECT TOP 1 1 Result FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'FUNCTION' AND ROUTINE_SCHEMA
Author:
KeithHyer
Date: 5/4/2010 Section:
Forum
Useful queries #3: Get SQL Server Edition, Version, Build and Last Update date and time.
Keeping track of all the versions and editions SQL Server instances can be a daunting task if you don?t have the right tools and documentation. A very easy way to obtain version, edition and build information from your SQL Servers is by querying the SERVE
Author:
JoseChinchilla_SQLJoe
Date: 10/11/2011 Section:
Blog
tags :
build
,
cumulative
,
edition
,
editions
,
service pack
,
SQL Server
,
update
Parameter Default Value from a query
I would love some input. Problem: Setting a default start date for a date parameter based on value from another parameter. The users do not like the drop down list and wants to use the Date picker API. User can pick predefined Recurrence levels – Select a
Author:
Mitch
Date: 6/3/2011 Section:
Forum
tags :
Default
,
Parameters
,
Values from a Query
D
atetime
conversion and varchar to nvarchar conversion error
Hope I understand your problem. You cant cast a datetime to int (DT_I4) without a transformation. If you want to convert "5/10/2010 12:00:00" to 20101005 you must: Assuming -field COL_DATETIME="5/10/2010 12:00:00" -destination field COL_INT in format YYYY
Author:
marcoadf
Date: 6/30/2010 Section:
Forum
Variable Expression - first day of current month
Sorry about that. I assumed since you said, "with no timestamp" that you meant you wanted it without any time on the end. To convert what either Daniel or I did to a datetime, create your variable as a DateTime data type and modify the expression with a t
Author:
KeithHyer
Date: 8/9/2011 Section:
Forum
tags :
datetime
Converting a date time to date in SSIS expressions
Most datetime expressions in SSIS include the time portion of the datetime as well as the date. The various system variable (CreationDate, StartTime) return a full datetime as well as the GetDate() expression function. What if you are only interested in t
Author:
RussLoski
Date: 1/20/2011 Section:
Blog
tags :
SSIS Expression Variable Date
expression in textbox
Syntax DATEDIFF ( interval , datetime , datetime ) you can't use 0 for datetime parameter interval Specifies the units (year, quarter, month, day, hour, minute, second or week) used to calculate the date difference. datetime Specifies the start date. date
Author:
Simona
Date: 5/17/2012 Section:
Forum
Using a Parameter in Sql Command in SSIS
Hello Rayan, Thanks for providing this post but when i am doing this with DateColumn i am getting this conversion error: In WHERE clause field VBRK-ERDAT, length 000014 must be less than or equal to 000010. Actually i am trying to take incremental data on
Author:
Jayesh
Date: 9/22/2011 Section:
Forum
Using a Parameter in Sql Command in SSIS
Hello Rayan, Thanks for providing this post but when i am doing this with DateColumn i am getting this conversion error: In WHERE clause field VBRK-ERDAT, length 000014 must be less than or equal to 000010. Actually i am trying to take incremental data on
Author:
Jayesh
Date: 9/22/2011 Section:
Forum
Function to Convert Int Date and Int Time to Single DateTime Value
Yesterday I was doing some work with the system tables in SQL Server 2008, specifically the tables related to jobs and job execution history. Those tables store dates and times in seperate fields as integer values, which is horrible for reporting. To reme
Author:
DustinRyan
Date: 5/14/2010 Section:
Blog
D
atetime
conversion and varchar to nvarchar conversion error
I think Marco had the right steps, but you'll need one last conversion to the correct string format and length before that final expression to get it to work. You can do all of that in one really long expression with the conversion to string being the fir
Author:
paschott
Date: 7/1/2010 Section:
Forum
Passing paremeters in SSIS
Hi, 1) Can anyone let me know how to pass paremeters in SSIS packages. 2) I have a function. I want to write that function using SSIS .Please let me know how to do that . Below is the function: ALTER FUNCTION [dbo].[GetReportingPeriodID] ( @ReportingFrom
Author:
Bhavika
Date: 4/13/2011 Section:
Forum
Error
Hi Here Im mapping Policy Number(nvarchar),Inception date(DateTimestamp),ExpiryDate(DateTimestamp) these three columns to destionation Policy table Policy Number(Varchar),InceptionDate(FK,Int),ExpiryDate(Fk,Int). so,i took oledb source and destination and
Author:
veni
Date: 7/10/2010 Section:
Forum
Page 1 of 5 (108 items)
<< Prev
1
2
3
4
5
Next >>
Go to page:
[Go]