Click here to Skip to main content
15,943,406 members
Home / Discussions / Database
   

Database

 
GeneralRe: How to prevent or allow a insert trigger ? Pin
GuyThiebaut10-Mar-14 4:52
professionalGuyThiebaut10-Mar-14 4:52 
QuestionSql Server Express: Testing sql-commands Pin
Frygreen9-Mar-14 3:03
Frygreen9-Mar-14 3:03 
AnswerRe: Sql Server Express: Testing sql-commands Pin
Richard MacCutchan9-Mar-14 3:33
mveRichard MacCutchan9-Mar-14 3:33 
AnswerRe: Sql Server Express: Testing sql-commands Pin
Jörgen Andersson9-Mar-14 7:42
professionalJörgen Andersson9-Mar-14 7:42 
AnswerRe: Sql Server Express: Testing sql-commands Pin
Mycroft Holmes9-Mar-14 13:05
professionalMycroft Holmes9-Mar-14 13:05 
AnswerRe: Sql Server Express: Testing sql-commands Pin
Richard Deeming10-Mar-14 2:49
mveRichard Deeming10-Mar-14 2:49 
GeneralRe: Sql Server Express: Testing sql-commands Pin
Frygreen10-Mar-14 7:40
Frygreen10-Mar-14 7:40 
Questionhow to convert an integer to days months years Pin
ahmad_yossef9-Mar-14 2:53
ahmad_yossef9-Mar-14 2:53 
how to convert an integer to days months years
i have a number of days resulted from sum of datediff to many rows as integer
i want to convert this days into days months years
like this

pr start end days_diff
-------------------------------------------------------
237 2010-06-01 2010-11-30 182
237 2010-12-01 2011-05-31 181
237 2011-06-01 2012-05-31 365
237 2012-06-01 2013-05-31 364
237 2013-06-01 2014-05-31 364

this total a 1456 days
i want to convert this days into
4 years 0 months 1 days
when i use the regular sum for each record into days months years it creates
3 years 12 months 1 days


or any way that produce the same result even not by calculate the sum of the days difference
but produce the same result
4 years 0 months 1 days
not
3 years 12 months 1 days


thanks for help

Lost & Forgotten
GeneralRe: how to convert an integer to days months years Pin
Kornfeld Eliyahu Peter9-Mar-14 3:25
professionalKornfeld Eliyahu Peter9-Mar-14 3:25 
GeneralRe: how to convert an integer to days months years Pin
ahmad_yossef10-Mar-14 21:16
ahmad_yossef10-Mar-14 21:16 
AnswerRe: how to convert an integer to days months years Pin
Kornfeld Eliyahu Peter10-Mar-14 21:30
professionalKornfeld Eliyahu Peter10-Mar-14 21:30 
GeneralRe: how to convert an integer to days months years Pin
ahmad_yossef10-Mar-14 22:15
ahmad_yossef10-Mar-14 22:15 
AnswerRe: how to convert an integer to days months years Pin
Kornfeld Eliyahu Peter10-Mar-14 22:27
professionalKornfeld Eliyahu Peter10-Mar-14 22:27 
AnswerRe: how to convert an integer to days months years Pin
Richard MacCutchan9-Mar-14 8:13
mveRichard MacCutchan9-Mar-14 8:13 
GeneralRe: how to convert an integer to days months years Pin
ahmad_yossef10-Mar-14 21:17
ahmad_yossef10-Mar-14 21:17 
GeneralRe: how to convert an integer to days months years Pin
Richard MacCutchan10-Mar-14 22:18
mveRichard MacCutchan10-Mar-14 22:18 
AnswerRe: how to convert an integer to days months years Pin
Richard Deeming10-Mar-14 2:40
mveRichard Deeming10-Mar-14 2:40 
QuestionMySQL Silent Installation Pin
Jassim Rahma6-Mar-14 9:41
Jassim Rahma6-Mar-14 9:41 
AnswerRe: MySQL Silent Installation Pin
Richard Deeming6-Mar-14 9:49
mveRichard Deeming6-Mar-14 9:49 
GeneralRe: MySQL Silent Installation Pin
Jassim Rahma6-Mar-14 9:52
Jassim Rahma6-Mar-14 9:52 
GeneralRe: MySQL Silent Installation Pin
Garth J Lancaster6-Mar-14 9:55
professionalGarth J Lancaster6-Mar-14 9:55 
GeneralRe: MySQL Silent Installation Pin
Jassim Rahma6-Mar-14 9:57
Jassim Rahma6-Mar-14 9:57 
AnswerRe: MySQL Silent Installation Pin
jschell7-Mar-14 9:28
jschell7-Mar-14 9:28 
QuestionSSRS reports shrinks on chrome browser Pin
Kenn20026-Mar-14 2:32
professionalKenn20026-Mar-14 2:32 
AnswerRe: SSRS reports shrinks on chrome browser Pin
Snehasish_Nandy7-Mar-14 19:14
professionalSnehasish_Nandy7-Mar-14 19:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.