在PB中有TIME型的数据类型吗?
在PB中有TIME型的数据类型吗? 问题点数:0、回复次数:7Top
1 楼winnet(网趣)回复于 2003-03-03 08:06:29 得分 0
兄弟,你不是吧,连有没有TIME型都不知道.我可以肯定地说:"有"
TIME 24小时制时间,包括小时(0-23),分(0-59),秒(00-59)以及秒的小数位(最多6位),
范围从00:00:00到23:59:59:999999Top
2 楼storm56(孤单的手)回复于 2003-03-03 08:12:56 得分 0
不要问PB有没有,而要问你连接的数据库系统有没有,我用oracle有DATETIME,而Top
3 楼weimin_wolf(老狼)回复于 2003-03-03 13:50:19 得分 0
有Top
4 楼shahand(死磕)回复于 2003-03-03 13:55:13 得分 0
Time
The time in 24-hour format, including the hour (00 to 23), minute (00 to 59), second (00 to 59), and fraction of second (up to six digits), with a range from 00:00:00 to 23:59:59:999999.
PowerBuilder supports microseconds in the database interface for any DBMS that supports microseconds.
Using literals The time in 24-hour format, including the hour (00 to 23), minute (00 to 59), second (00 to 59), and fraction of second (up to six digits), with a range from 00:00:00 to 23:59:59.999999. You separate parts of the time with colons梕xcept for fractional sections, which should be separated by a decimal point. For example:
21:09:15 // 15 seconds after 9:09 pm
06:00:00 // Exactly 6 am
10:29:59 // 1 second before 10:30 am
10:29:59.9 // 1/10 sec before 10:30 amTop
5 楼xiangyiwei(NightSky)回复于 2003-03-05 15:55:17 得分 0
当然有Top
6 楼dancer(似水流年)回复于 2003-03-05 16:09:51 得分 0
哎,当然是问哪些数据库里有time型了
一般大型数据库都有datetime型的Top
7 楼tchatcha(沧桑,孤独,浪漫,但执着!)回复于 2003-03-05 17:27:52 得分 0
dancer() 说的不错
upTop




