在pl/sql中显示星期几的程序 [英] program to diplay days of week in pl/sql

问题描述

请帮助我........
如何使程序在pl/sql中显示日期名称

[edit]已删除呼喊声-OriginalGriff [/edit]

Plz help me...........
How to make program to diplay name of days in pl/sql

[edit]SHOUTING removed - OriginalGriff[/edit]

推荐答案

尝试使用SQL(根据标记):

Try this for SQL (according to the tag):

SELECT DATENAME(dw, GETDATE())
-- or
SELECT DATENAME(dw, 1)

请尝试使用pl/sql:-

Try this for pl/sql:-

SELECT TO_CHAR((sysdate - (TO_CHAR(sysdate,''d'') - 1)),''Day'') 
FROM DUAL;

如果您有帮助，请不要忘记将其标记为答案.

谢谢

Please don''t forget to mark this as your answer if it helps you out.

Thanks

这篇关于在pl/sql中显示星期几的程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！