日期问题

ranliwei 2003-10-22 10:19:50

如何将表单中显示的格式由月、日、年变成年、月、日

...全文

78 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

mzzxy 2003-10-23

打赏
举报

allt(str(year(date())))+'年'+allt(str(month(date())))+'月'+allt(str(day(date())))+'日'

dfwxj 2003-10-23

打赏
举报

完善一下楼上的答案：

str(year(date())，4)+'年'+padl(allt(str(month(date()))),2,'0')+'月'+padl(allt(str(day(date()))),2,'0')+'日'

dfwxj 2003-10-22

打赏
举报

set date ansi

搞定！

magnetmoon 2003-10-22

打赏
举报

set date to ymd
?date()
set date to mdy
?date()
set date to dmy
?date()

fengyeng 2003-10-22

打赏
举报

工具/选项/区域
日期格式
选择汉语就可以了
看完速给分！

noproblem12 2003-10-22

打赏
举报

set date YMD

noproblem12 2003-10-22

打赏
举报

SET DATE Command
See Also

Specifies the format for the display of Date and DateTime expressions.

Syntax

SET DATE [TO] AMERICAN | ANSI | BRITISH | FRENCH | GERMAN
| ITALIAN | JAPAN | USA | MDY | DMY | YMD
| SHORT | LONG

Remarks

Here are the settings and the resulting date formats:

Setting Format
AMERICAN mm/dd/yy
ANSI yy.mm.dd
BRITISH/FRENCH dd/mm/yy
GERMAN dd.mm.yy
ITALIAN dd-mm-yy
JAPAN yy/mm/dd
USA mm-dd-yy
MDY mm/dd/yy
DMY dd/mm/yy
YMD yy/mm/dd
SHORT Short date format determined by the Windows Control Panel short date setting.
LONG Long date format determined by the Windows Control Panel long date setting. Note that when SET DATE is set to LONG, dates before {^1601-01-01} that are converted to character strings are returned as the empty date.

The default date setting is AMERICAN.

The SET DATE setting also determines how the date appears in datetime expressions.

If DATE is set to SHORT or LONG, the SET CENTURY, SET MARK, SET HOURS, and SET SECONDS settings are ignored.

SET DATE is scoped to the current data session.

taoyb 2003-10-22