Need to load date from datepart from a table to a file

Question

Post reply

Need to load date from datepart from a table to a file

komal145

SSCrazy Eights

Points: 9918
More actions
August 9, 2016 at 4:07 pm

#310381

I have a table with datetime column something like this : 08-09-2016 00:00:00
I would like to get only 08-09-2016 from this column while loading to a text file.
I used derived column with expression something like this : (DT_DBDATE)[Date]
This is still not working. Need help
Thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

The CONVERT function supports the format you want to use. Just apply it to a column instead.

SELECT CONVERT(Varchar(10), GETDATE(), 110);

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 2

Ed Wagner (8/10/2016)
The CONVERT function supports the format you want to use. Just apply it to a column instead.
SELECT CONVERT(Varchar(10), GETDATE(), 110);

Do T-SQL functions actually work inn SSIS, Ed? I thought you had to use "DTS" functions only unless it was in a T-SQL script task or stored procedure.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

komal145 SSCrazy Eights Points: 9918 More actions · Answer 3

I tried the same...but no use. it still appends 0's for hh:mm:ss. 2016-07-18 00:00:00

I don't need 0's appended at last.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

Jeff Moden (8/10/2016)
Ed Wagner (8/10/2016)
The CONVERT function supports the format you want to use. Just apply it to a column instead.
SELECT CONVERT(Varchar(10), GETDATE(), 110);
Do T-SQL functions actually work inn SSIS, Ed? I thought you had to use "DTS" functions only unless it was in a T-SQL script task or stored procedure.

Doh! I guess I wasn't caffeinated enough yet. Thanks.

Komal, skip my post. Sorry about that.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Luis Cazares SSC Guru Points: 183706 More actions · Answer 5

To get a specific format from a date into a file, you need to convert it to string.

It's certainly easier to format with a SQL query than with SSIS. If you don't want to use a query as a source in your SSIS package, create a view from the table which returns all the desired formats and use that as a source. Remember to keep your columns as strings, as that the only way to ensure the desired format.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2