| SELECT SUBSTRING("20230910", 1, 8) = DATE_FORMAT(NOW(), '%Y%m%d') AS yes
|
1 year ago |
| SELECT SUBSTRING("20230808", 1, 8) = DATE_FORMAT(NOW(), '%Y%m%d') AS yes
|
1 year ago |
| SELECT SUBSTRING("20230808", 0, 2) AS yes
|
1 year ago |
| SUBSTRING("20230808", 0, 2)
|
1 year ago |
| SELECT SUBSTRING("20230808", 0, 2)
|
1 year ago |
| SELECT DATE_FORMAT(NOW(), '%Y%m%d') AS FormattedDate;
|
1 year ago |
| SELECT TO_CHAR(CURRENT_DATE, 'YYYYMMDD') AS FormattedDate;
|
1 year ago |
| SELECT TO_CHAR(CURRENT_DATE, 'YYYYMMDD') AS FormattedDate;
|
1 year ago |
| SELECT FORMAT(GETDATE(), 'yyyyMMdd') AS FormattedDate;
|
1 year ago |
| SELECT CURRENT_TIMESTAMP |
1 year ago |
| SHOW CURRENT_TIMESTAMP |
1 year ago |
| SELECT AVG(num_revisions) AS... |
1 year ago |
| SELECT AVG(num_revisions) AS... |
1 year ago |
| SELECT AVG(num_revisions) AS... |
1 year ago |
| SELECT DAY(CURRENT_TIMESTAMP) AS DayOfMonth;
|
1 year ago |
| SELECT DAY(GETDATE()) AS DayOfMonth;
|
1 year ago |
| SELECT SUBSTRING('20230825', 6, 2) AS current_unix_time;
|
1 year ago |
| SELECT DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME('20230825'), 'UTC', 'CST'),... |
1 year ago |
| SELECT UNIX_TIMESTAMP(DATE_SUB(CURRENT_DATE, INTERVAL 10 DAY)) AS current_unix_time;
|
1 year ago |
| SELECT UNIX_TIMESTAMP(CURDATE()) AS current_unix_time;
|
1 year ago |
| SELECT UNIX_TIMESTAMP(CURDATE() - INTERVAL 10 DAY) AS current_unix_time;
|
1 year ago |
| SELECT UNIX_TIMESTAMP() AS current_unix_time;
|
1 year ago |
| SHOW TABLES |
1 year ago |
