MM/DD/YYYY
To apply United States formatting conventions, use the Set Format statement. To avoid the issue
of how your computer is set up, call the NumberToDate() function, which is not affected by your
computer set up.
When entering data into a DateTime field in the MapInfo Pro Browser window or Info tool, the value
processes as a string. Quotes are not necessary around the value and time separators, such as a
backslash (/) and colon (:), are accepted. The exception is the Update Column dialog, which requires
quotes around string values.
Functions that return a DateTime value are:
• CurDateTime()
• MakeDateTime()
• NumberToDateTime()
• StringToDateTime()
Date
A Date value is an integer representing the date in a YYYYMMDD format, where YYYY is the year,
MM is the month between 01 (January) and 12 (December), and DD is the day of the month between
01 and 31.
Functions that return a DateTime value are CurDate() function, GetDate() function, and
NumberToDate() function.
Time
A Time value is an nine-digit integer in the form hhmmssfff, where hh is hour, mm is minutes, ss is
seconds, and fff is fractions. For example, 214237582 represents 9:42:37.582 P.M.
Functions that return a Time value are:
• CurTime()
• GetTime()
• NumberToTime()
• StringToTime()
A function like FormatTime$() function lets you specify the time format to apply to the output. You
should follow the same Microsoft standards as for setting the locale time format as outlined in the
following list. The letters m, s, and t must be lowercase and the letter h must be lowercase (h) to
denote the 12-hour clock or uppercase (H) to denote the 24-hour clock. In addition to this, you can
also specify f, ff, or fff for tenths of a second, hundredths of a second, or milliseconds.
MeaningHours
Hours without leading zeros for single-digit hours (12-hour clock).h
16MapBasic 17.0 Reference
Introduction to MapBasic
剩余1128页未读，继续阅读
白衣侠客走江湖
- 粉丝: 6
- 资源: 39
我的内容管理
展开
最新资源
- 前端面试必问：真实项目经验大揭秘
- 永磁同步电机二阶自抗扰神经网络控制技术与实践
- 基于HAL库的LoRa通讯与SHT30温湿度测量项目
- avaWeb-mast推荐系统开发实战指南
- 慧鱼SolidWorks零件模型库：设计与创新的强大工具
- MATLAB实现稀疏傅里叶变换(SFFT)代码及测试
- ChatGPT联网模式亮相，体验智能压缩技术.zip
- 掌握进程保护的HOOK API技术
- 基于.Net的日用品网站开发：设计、实现与分析
- MyBatis-Spring 1.3.2版本下载指南
- 开源全能媒体播放器：小戴媒体播放器2 5.1-3
- 华为eNSP参考文档：DHCP与VRP操作指南
- SpringMyBatis实现疫苗接种预约系统
- VHDL实现倒车雷达系统源码免费提供
- 掌握软件测评师考试要点：历年真题解析
- 轻松下载微信视频号内容的新工具介绍
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
