ORACLE APEX 形式的 SYSDATE
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13393481/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SYSDATE IN ORACLE APEX FORMS
提问by Usman YousafZai
I am working in APEX forms .Here i have table A with the column Date.Here date picker is by default.i want to change the date picker to "SYSDATE" i-e to show the sysdate on the form not to choose it.Please help me out
我在 APEX 表单中工作。这里我有一个表 A 与列 Date.Here 日期选择器是默认的。我想将日期选择器更改为“SYSDATE”，即在表单上显示系统日期而不是选择它。请帮忙我出去
Regards,
问候，
回答by J?cob
In the item where you want to set sysdate as default
在要将 sysdate 设置为默认值的项目中
Choose PL/SQL Expressionand for the value give
选择PL/SQL Expression并为价值给出
to_char(sysdate,'DD-MON-YYYY')
So you have the sysdate as default value.
所以你有 sysdate 作为默认值。
回答by Sherafgan
For setting sysdate as default date just open the date settings , change the default value type to PL/SQL Expression and for the value
要将 sysdate 设置为默认日期，只需打开日期设置，将默认值类型更改为 PL/SQL 表达式和值
give (to_char(sysdate,'DD-MON-YYYY')) it will work.
给 (to_char(sysdate,'DD-MON-YYYY')) 它会起作用。
u can also change the date pickings from the form editing page.
您还可以从表单编辑页面更改日期选择。
