recentpopularlog in

Date

« earlier   
date - Create a time (by half hours) table in MySQL - Stack Overflow
Before sequence engine:

SELECT
DATE('2010/01/01') + INTERVAL (NR * 30) MINUTE AS mydate
FROM (
SELECT d2.a*10+d1.a AS nr FROM (
SELECT 0 a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS d1
CROSS JOIN (
SELECT 0 a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 ) AS d2
WHERE d2.a*10+d1.a BETWEEN 0 AND 47
) AS parameter
ORDER BY nr;
mysql  date  sequence  half  hour  hours 
20 hours ago by theskett
Add a date to a SQL*Plus spool file name
sqlplus user/password
col spoolname new_value spoolname

select 'invoice_'||to_char(sysdate, 'yymmdd') spoolname from dual

spool '&spoolname'

select stuff . . . .
spool off
oracle  database  sql  spool  date  time 
2 days ago by iteruel
Holiday API
> a RESTful service for obtaining holiday data
api  resources  holiday  code  date  web  calendar 
13 days ago by jefftriplett

Copy this bookmark:





to read