MYsql的函数
DATENAME(dw, (2008-02-05)) as 星期,
DATEDIFF(hh, GETDATE(), (2008-02-05 16:29:40)) > 0)
如何转换成PostGreSQL啊用什么函数啊.在线等啊.
DATENAME(dw, (2008-02-05)) as 星期,
DATEDIFF(hh, GETDATE(), (2008-02-05 16:29:40)) > 0)
如何转换成PostGreSQL啊用什么函数啊.在线等啊.
调试欢乐多
每周的星期号(0 - 6;星期天是 0) (仅用于 timestamp)
SELECT EXTRACT(DOW FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 5