string(datatime)急!

2007-12-27 10:48:38 132 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

MongoDB启动失败(service mongod start)：Failed to unlink socket file /tmp/mongodb-27017.sock Unknown error 错误日志（/var/log/mongodb/mongo.log）： 2019-09-16T06:00:00.251+0000 I CONTROL [main] ***** SERVER RESTARTED ***** 2019-09-16T06:00:00.253+0000 I CONTROL [main] Automatically disabling TLS 1.0, to force-e... 阅读详情

string(datatime)转换后是为什么值?如:string(2007-12-21 12:01:01)结果为多少?

...全文

Kerberos基础及KDC服务（理论知识） kerberos基础理论讲解+KDC服务阅读详情

wuyuchang

PowerBuilder 1,111 成员 66,454 内容

+ 关注 + 加入社区

切换为时间正序

wuyuchang 2007-12-27

打赏
举报

那我不写格式呢?返回是datetime吗?

jlwei888 2007-12-27

打赏
举报

string(2007-12-21 12:01:01,"yyyymmdd") = '20071221'
string(2007-12-21 12:01:01,"yyyymmdd hh:mm:ss") = '20071221 12:01:01'

你想要什么格式，就写什么的参数！

wuyuchang 2007-12-27

打赏
举报

返回不是2007-12-21吗?

worldly_wind 2007-12-27

打赏
举报

用String(DateTime(2007-12-21 12:01:01))返回2007-12-21 12:01:01

leio 2007-12-27

打赏
举报

去查PB联机帮助，可以有很多种格式。

This statement applies a display format to a date value and returns Jan 31, 2002:

String(2002-01-31, "mmm dd, yyyy")

This example applies a format to the value in order_date and sets date1 to 6-11-02:

Date order_date = 2002-06-11

string date1

date1 = String(order_date,"m-d-yy")

This example includes a format for a null date value so that when order_date is null, date1 is set to none:

Date order_date = 2002-06-11

string date1

SetNull(order_date)

date1 = String(order_date, "m-d-yy;'none'")

This statement applies a format to a DateTime value and returns Jan 31, 2001 6 hrs and 8 min:

String(DateTime(2001-01-31, 06:08:00), &

'mmm dd, yyyy h "hrs and" m "min"')

This example builds a DateTime value from the system date and time using the Today and Now functions. The String function applies formatting and sets the text of sle_date to that value, for example, 6-11-02 8:06 pm:

DateTime sys_datetime

string datetime1

sys_datetime = DateTime(Today(), Now())

sle_date.text = String(sys_datetime, &

"m-d-yy h:mm am/pm;'none'")

This statement applies a format to a numeric value and returns $5.00:

String(5,"$#,##0.00")

These statements set string1 to 0123:

integer nbr = 123

string string1

string1 = String(nbr,"0000;(000);****;empty")

These statements set string1 to (123):

integer nbr = -123

string string1

string1 = String(nbr,"000;(000);****;empty")

These statements set string1 to ****:

integer nbr = 0

string string1

string1 = String(nbr,"0000;(000);****;empty")

These statements set string1 to "empty":

integer nbr

string string1

SetNull(nbr)

string1 = String(nbr,"0000;(000);****;empty")

This statement formats string data and returns A-B-C. The display format assigns a character in the source string to each @ and inserts other characters in the format at the appropriate positions:

String("ABC", "@-@-@")

This statement returns A*B:

String("ABC", "@*@")

This statement returns ABC:

String("ABC", "@@@")

This statement returns a space:

String("ABC", " ")

This statement applies a display format to time data and returns 6 hrs and 8 min:

String(06:08:02,'h "hrs and" m "min"')

This statement returns 08:06:04 pm:

String(20:06:04,"hh:mm:ss am/pm")

This statement returns 8:06:04 am:

String(08:06:04,"h:mm:ss am/pm")

jlwei888 2007-12-27

打赏
举报

晕！
不知你要什么
string(2007-12-21 12:01:01)　返回　"2007-12-21 12:01:01"
是个string

String是什么的，你知道吗？

你如果还不会就看书吧！
或自己做个试试不就知道了吗？

string(datatime)急!

相关推荐