Number to dial day month year - 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

SQL Server 2008 Forums

Transact-SQL (2008)

Number to dial day month year

Author

Topic

xnanx
Starting Member

4 Posts

Posted - 2011-06-20 : 03:50:42

Hello,
Number to dial day month year,

Sample; get number '3723'

3723 = 10 Years, 2 Month, 13 days

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2011-06-20 : 04:06:34

select 3723/365,(3723%365)/30,(3723%365)%30

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

xnanx
Starting Member

4 Posts

Posted - 2011-06-20 : 04:21:58

Thank you Senthil.C,
is a negative value. How can I prevent this.

dbo.LH_001_PERSON.INDATE AS ISEGIRIS_TARIHI, DATEDIFF(DAY, dbo.LH_001_PERSON.INDATE, GETDATE()) AS KIDEM_GUNU, STR(DATEDIFF(DAY,
dbo.LH_001_PERSON.INDATE, GETDATE()) / 365) + ' YIL ' + STR(DATEDIFF(MONTH, dbo.LH_001_PERSON.INDATE, GETDATE()) - 12 * FLOOR(DATEDIFF(DAY,
dbo.LH_001_PERSON.INDATE, GETDATE()) / 365)) + ' AY ' + STR((DATEDIFF(DAY, dbo.LH_001_PERSON.INDATE, GETDATE()) - 365 * DATEDIFF(YEAR,
dbo.LH_001_PERSON.INDATE, GETDATE())) - 30 * (DATEDIFF(MONTH, dbo.LH_001_PERSON.INDATE, GETDATE()) - 12 * DATEDIFF(YEAR,
dbo.LH_001_PERSON.INDATE, GETDATE()))) + ' GUN' AS KIDEMI

Translate to english: Yil= Years, Ay= Month, Gün= Days

should be
9 YIL , 1 Ay, 28 Gün

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources