few clarifications in coverting date to string literals

Question

few clarifications in coverting date to string literals

manibad

SSCommitted

Points: 1556
More actions
March 1, 2013 at 10:50 am

#290143

I need to work on SSIS in converting date format to string literals.
1)Input:2013-03-01
Output:03-March-2013
2)First day of the following month
Input:2013-01-01
Output:2013-02-01
(or)
input:2013-12-29
Output:2014-01-01
I need to satisfy both conditions in a single query
I need to work on both the coniditions but i am unbale to solve it.
Please help me on both.
Thanks in advance.

Viewing 3 posts - 1 through 2 (of 2 total)

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

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 1

manibad (3/1/2013)
I need to work on SSIS in converting date format to string literals.
1)Input:2013-03-01
Output:03-March-2013
2)First day of the following month
Input:2013-01-01
Output:2013-02-01
(or)
input:2013-12-29
Output:2014-01-01
I need to satisfy both conditions in a single query
I need to work on both the coniditions but i am unbale to solve it.
Please help me on both.
Thanks in advance.

From what I understand, formatting dates in SSIS requires the concatenation of date parts. I suspect doing the date math in SSIS is a bit more difficult.

With that in mind, I'd do this in T-SQL query. Let us know if that'll fill your need.

My concern is, why do you want to do #1 at all? If it's to store formatted dates in a table, be advised that's one of the worst practices of all.

--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)

manibad SSCommitted Points: 1556 More actions · Answer 2

SORRY For guiding you wrong..i need to throw those formats as string literals in text files and not loading those in tables...