我想問用access 的SQL 點樣set 個date format

2006-10-28 8:28 pm
select date from datebook

如果用上面個條佢會show 的format 是:11/1/2006 12:00:00 AM
我想show 成:11/1/2006 星期X

請幫幫我,謝謝

回答 (1)

2006-10-29 7:46 am
✔ 最佳答案
pls try

date() & “ ” & weekdayname(weekday(date()),false,1)

but i′m using english version. so it only can show “Saturday”
is it OK?


收錄日期: 2021-04-23 15:45:37
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20061028000051KK01615

檢視 Wayback Machine 備份