15,745,005 members
Home / Discussions / Database

# Database

 Re: to set foreign key or not to set? _AK_13-Mar-14 11:21 _AK_ 13-Mar-14 11:21
 Group by (first letter) nelsonpaixao12-Mar-14 16:42 nelsonpaixao 12-Mar-14 16:42
 Re: Group by (first letter) Kornfeld Eliyahu Peter12-Mar-14 20:03 Kornfeld Eliyahu Peter 12-Mar-14 20:03
 Re: Group by (first letter) nelsonpaixao16-Mar-14 9:50 nelsonpaixao 16-Mar-14 9:50
 Re: sum of datediff to many dates Tim Carmichael11-Mar-14 5:40 Tim Carmichael 11-Mar-14 5:40
 Re: sum of datediff to many dates ahmad_yossef11-Mar-14 23:05 ahmad_yossef 11-Mar-14 23:05
 Re: sum of datediff to many dates Tim Carmichael12-Mar-14 10:57 Tim Carmichael 12-Mar-14 10:57
 ahmad_yossef wrote:i want to convert this days (integer) to years months and days Well, break it down.. if you have the number of days, how many days in a year? Let's assume 365; so number of years in int(number of days / 365). Months... let's assume 30 days on average... Months = int((number of days - years * 365) / 30) And days are then number of days - years * 365 - months * 30 If that doesn't work, better define what you're after. Given the sample dates you provided, what are the values you calculated for years, months and days?
 Re: sum of datediff to many dates ahmad_yossef12-Mar-14 23:19 ahmad_yossef 12-Mar-14 23:19
 Re: sum of datediff to many dates Richard Deeming13-Mar-14 1:10 Richard Deeming 13-Mar-14 1:10
 Re: sum of datediff to many dates Kornfeld Eliyahu Peter11-Mar-14 23:48 Kornfeld Eliyahu Peter 11-Mar-14 23:48
 Re: sum of datediff to many dates ahmad_yossef12-Mar-14 2:23 ahmad_yossef 12-Mar-14 2:23
 Re: sum of datediff to many dates Richard MacCutchan12-Mar-14 3:53 Richard MacCutchan 12-Mar-14 3:53
 Re: sum of datediff to many dates jschell14-Mar-14 12:15 jschell 14-Mar-14 12:15
 DSN Lek Plepi11-Mar-14 1:27 Lek Plepi 11-Mar-14 1:27
 Re: DSN cdpsource11-Mar-14 2:14 cdpsource 11-Mar-14 2:14
 Re: DSN Mycroft Holmes11-Mar-14 2:25 Mycroft Holmes 11-Mar-14 2:25
 Ho to avoid Not In & In clause in my query member002611-Mar-14 0:43 member0026 11-Mar-14 0:43
 Re: Ho to avoid Not In & In clause in my query Bernhard Hiller11-Mar-14 1:04 Bernhard Hiller 11-Mar-14 1:04
 Re: Ho to avoid Not In & In clause in my query member002611-Mar-14 18:08 member0026 11-Mar-14 18:08
 Re: Ho to avoid Not In & In clause in my query thatraja11-Mar-14 2:07 thatraja 11-Mar-14 2:07
 Re: Ho to avoid Not In & In clause in my query GuyThiebaut11-Mar-14 3:54 GuyThiebaut 11-Mar-14 3:54
 Adding Sales Totals from multiple tables jkirkerx9-Mar-14 10:54 jkirkerx 9-Mar-14 10:54
 Re: Adding Sales Totals from multiple tables Mycroft Holmes9-Mar-14 14:16 Mycroft Holmes 9-Mar-14 14:16
 Re: Adding Sales Totals from multiple tables jkirkerx9-Mar-14 17:44 jkirkerx 9-Mar-14 17:44
 Last Visit: 31-Dec-99 18:00     Last Update: 27-Sep-23 6:38 Refresh ᐊ Prev1...204205206207208209210211212213 Next ᐅ