date-arithmetic
PL/SQL procedure random timestamp
how i can generate a random timestamp and put it into 开发者_运维百科a var? Thanks, TommasoI found this solution[详细]
2023-02-12 04:26 分类:问答Getting Last Day of Previous Month in Oracle Function
I need a function in Oracle like this. When i giving a parameter a simple date. Then function should getting me last day of the previous month.[详细]
2023-02-09 13:21 分类:问答How curdate() works in comparisons in MySQL
I\'m trying to retrieve entries in my DB using curdate() and I think there is some underlying logic that I\'m unaware of. For instance:[详细]
2023-02-07 14:13 分类:问答Oracle PL/SQL datetime math - intervals
I\'ve been using syntax like {?EndDate} - INTERVAL \'1\' YEAR for a while now, and I knew开发者_高级运维 there was an issue that I was going to hit eventually, and I just hit it. I tried to do DATE \'[详细]
2023-02-06 08:13 分类:问答Difference between two dates
I have a table that has the following data fromDate | toDate 20JAN11| 29DEC30 Both dates are for the 21st Century (i.e. 2011 and 2030) but only the last two characters are stored.[详细]
2023-02-06 05:34 分类:问答Most efficient way in MySQL to retrieve values in a given week?
I need to produce a report that provides the count of each particular promotional code used within a particular week.Example table structure:[详细]
2023-01-29 03:32 分类:问答Delete rows with date older than 30 days with SQL Server query
I need a SQL statement to delete row that are older than 30 days. My table even开发者_高级运维ts has a field date that contains the date and the time it was inserted in the database.[详细]
2023-01-28 08:21 分类:问答calculating call duration
i am wo开发者_开发问答rking for telecom,i need to calculate call duration of a call.the issue is we have world time 24hrs(00:00:00 - 23:59:59)for example, now the call starts at 22:31:40 and ends at 0[详细]
2023-01-28 07:33 分类:问答How to get list of monthly periods?
I have starting date and number of months. I need to create specific number of monthly periods for example:[详细]
2023-01-28 05:44 分类:问答MySQL: Average interval between records
Assume this table: iddate ---------------- 12010-12-12 22010-12-13 32010-12-18 42010-12-22 52010-12-23 How do I find the average intervals between these dates, using MySQL q开发者_运维知识库ueries[详细]
2023-01-27 19:10 分类:问答