FAQ > 金融建模 > 数据提取 > 行情数据
Q：如何将半秒线行情数据的时间戳显示出毫秒？
- A：普通的datetimetostr只能显示时间点到秒，若需要显示毫秒，需要调用FormatDateTime进行自定义格式的转换。
范例：
setsysparam(pn_cycle(),cy_halfs());
return select *,FormatDateTime('yyyy-mm-dd hh:nn:ss:zzz',['date']) as 'date'
from markettable
datekey 20191223T to 20191223.15T of 'IF00' end;
返回：StockID StockName date price open close high low vol amount … IF00 300期货主力合约 2019-12-23 09:30:00:000 4,030.80 4,031.00 4,030.80 4,033.60 4,030.80 196.00 237,035,160.00 IF00 300期货主力合约 2019-12-23 09:30:00:500 4,031.60 4,031.60 4,031.60 4,031.60 4,030.40 41.00 49,589,280.00 IF00 300期货主力合约 2019-12-23 09:30:01:000 4,030.20 4,030.20 4,030.20 4,030.20 4,030.20 23.00 27,817,200.00 IF00 300期货主力合约 2019-12-23 09:30:01:500 4,031.80 4,031.80 4,031.80 4,031.80 4,031.80 31.00 37,489,560.00 IF00 300期货主力合约 2019-12-23 09:30:02:000 4,031.60 4,031.60 4,031.60 4,031.60 4,031.60 25.00 30,235,920.00 IF00 300期货主力合约 2019-12-23 09:30:02:500 4,031.00 4,031.00 4,031.00 4,031.00 4,031.00 14.00 16,930,080.00 IF00 300期货主力合约 2019-12-23 09:30:03:000 4,031.00 4,031.00 4,031.00 4,031.00 4,031.00 9.00 10,884,840.00 IF00 300期货主力合约 2019-12-23 09:30:03:500 4,030.80 4,030.80 4,030.80 4,030.80 4,030.80 6.00 7,256,100.00 IF00 300期货主力合约 2019-12-23 09:30:04:000 4,031.60 4,031.60 4,031.60 4,031.60 4,031.60 14.00 16,930,620.00 IF00 300期货主力合约 2019-12-23 09:30:04:500 4,031.00 4,031.00 4,031.00 4,031.00 4,031.00 34.00 41,112,480.00 IF00 300期货主力合约 2019-12-23 09:30:05:000 4,029.80 4,029.80 4,029.80 4,029.80 4,029.80 42.00 50,785,320.00 IF00 300期货主力合约 2019-12-23 09:30:05:500 4,029.80 4,029.80 4,029.80 4,029.80 4,029.60 23.00 27,807,660.00 IF00 300期货主力合约 2019-12-23 09:30:06:000 4,029.60 4,029.60 4,029.60 4,029.60 4,029.20 17.00 20,551,440.00 IF00 300期货主力合约 2019-12-23 09:30:06:500 4,029.80 4,029.80 4,029.80 4,029.80 4,029.80 5.00 6,044,280.00 IF00 300期货主力合约 2019-12-23 09:30:07:000 4,029.60 4,029.60 4,029.60 4,029.60 4,029.60 13.00 15,715,260.00 IF00 300期货主力合约 2019-12-23 09:30:07:500 4,029.60 4,029.60 4,029.60 4,029.60 4,029.00 13.00 15,715,260.00 …