How to prepare a full date using month & year

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

I have a Month & year , using that i want to display total date with day is -01 and time is 0's.

How to achieve this

ex:

month -3

year-2013

i want to display this is first day of march like '2013-03-01 00:00:00'

i'm using something like this but this is not given exact result

SQL

cast(year(release_date) as char(5))+'-'+cast(month(release_date) as char(2))+'-'+'01 00:00:00'

using this month returns 3, so the result becomes like this 2013-3-01 00:00:00, but this is not in correct format na.....

Posted 4-Mar-13 15:56pm

Naveen.Sanagasetti

Updated 4-Mar-13 16:01pm

v2

Add a Solution

Comments

gvprabu 6-Mar-13 22:01pm

Hi Naveen,
Check my post... its useful to you or not? :-)

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Naveen.Sanagasetti · Answer 1 · 2013-03-04T16:26:00

My self to resolve this issue...

Using this

SQL

convert (datetime ,cast(year(release_date) as varchar(4))+right('00'+cast(month(release_date) as varchar(2)),2)+right('00' + cast(@day as varchar(2)),2)) AS Release_Date

It might be helpfull to some other , who are confusing about the same issue..

gvprabu · Answer 2 · 2013-03-04T17:39:00

Solution 3

Hi....

Its very simple ... try this :-) :-) :-)

SQL

DECLARE @CurDate DATETIME=GETDATE()
 
SELECT CONVERT(DATETIME,CAST(YEAR(@CurDate) AS VARCHAR(5))+'-'+CAST(MONTH(@CurDate)AS VARCHAR(5))+'-01',101) 'ReqDate'

ReqDate
----------------------
2013-03-01 00:00:00.000

Posted 4-Mar-13 17:39pm

gvprabu

Updated 4-Mar-13 17:52pm

v3

Davidduraisamy · Answer 3 · 2013-03-04T17:34:00

Solution 2

Check this:

SELECT CAST(YEAR(GETDATE())AS VARCHAR(4))+'-'+ CAST( MONTH(GETDATE())AS VARCHAR(4))+'-'+ CAST(01 AS VARCHAR(2))+' '+CAST('00:00:00' AS VARCHAR(10))

Posted 4-Mar-13 17:34pm

Davidduraisamy

Updated 4-Mar-13 17:35pm

v2