date - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

date

Author

Topic

wided
Posting Yak Master

218 Posts

Posted - 2010-02-18 : 08:46:22

J'ai besoin de trouver une date (jour, mois année) sachant que j'ai uniquement comme valeur, le numéro de la semaine et l'année

Merci de me répondre

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-18 : 08:48:12

can you please translate this in English?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-02-18 : 08:52:29

Do you mean this?
DECLARE @Dt datetime
SELECT @Dt='20100218'
SELECT right('00'+convert(varchar(2),DATEPART( wk, @Dt)),2)+convert(varchar(4),year(@Dt))

No, you're never too old to Yak'n'Roll if you're too young to die.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-18 : 08:54:20

quote:
Originally posted by webfred

Do you mean this?
DECLARE @Dt datetime
SELECT @Dt='20100218'
SELECT right('00'+convert(varchar(2),DATEPART( wk, @Dt)),2)+convert(varchar(4),year(@Dt))

No, you're never too old to Yak'n'Roll if you're too young to die.

So the original language was German

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-02-18 : 08:56:28

No, it is French

No, you're never too old to Yak'n'Roll if you're too young to die.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-18 : 09:00:09

quote:
Originally posted by webfred

No, it is French

No, you're never too old to Yak'n'Roll if you're too young to die.

Thought it might be German as you decoded it fast

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-02-18 : 09:06:12

dépendant de la version
version 2008: chercher ISO_WEEK

No, you're never too old to Yak'n'Roll if you're too young to die.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-02-18 : 09:12:16

quote:
Originally posted by webfred

Do you mean this?
DECLARE @Dt datetime
SELECT @Dt='20100218'
SELECT right('00'+convert(varchar(2),DATEPART( wk, @Dt)),2)+convert(varchar(4),year(@Dt))

No, you're never too old to Yak'n'Roll if you're too young to die.

What does OP want?

Madhivanan

Failing to plan is Planning to fail

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-02-18 : 09:14:56

If my French is any good...I think he wants to find the date when he only has the number of weeks from the start of the year??

EDIT : OK..I think OP has started another thread..and he already stated his question in English

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=140075

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-02-18 : 09:18:15

I have mistaken - sorry my French is rusty.

No, you're never too old to Yak'n'Roll if you're too young to die.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-02-18 : 09:20:44

Here he stated that he wants a date from a given week and year.
In his other thread he wants a date from given number of days and year.

No, you're never too old to Yak'n'Roll if you're too young to die.