pgSQL to_date
时间: 2023-09-14 15:11:11 浏览: 132
在pgSQL中,to_date函数用于将字符串转换为日期。然而,该函数仅转换年月日部分,并且无论在函数中指定的日期格式如何,都只会转换年月日。例如,使用to_date函数转换字符串'2019-01-15 18:33:41',结果仅为日期部分,即'2019-01-15'。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [postgresql 踩坑系列 关于to_date()](https://blog.csdn.net/qq_36273946/article/details/86546350)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *3* [PGSQL to_date转换年月日时分秒发现格式不对](https://blog.csdn.net/a984171281/article/details/120329794)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文