Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies如何在 MongoDB 中將字串轉換為日期資料型別？
要將字串轉換為日期資料型別，你需要編寫一些指令碼。讓我們首先建立一個包含文件的集合
>db.stringToDateDataTypeDemo.insertOne({"CustomerName":"Carol","ShippingDate":"2019-
01-21"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ca2071d66324ffac2a7dc60")
}
>db.stringToDateDataTypeDemo.insertOne({"CustomerName":"Bob","ShippingDate":"2019-
02-24"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ca2073566324ffac2a7dc61")
}
>db.stringToDateDataTypeDemo.insertOne({"CustomerName":"Chris","ShippingDate":"2019-
04-01"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ca2074266324ffac2a7dc62")
}以下是使用 find() 方法從集合顯示所有文件的查詢
> db.stringToDateDataTypeDemo.find().pretty();
這將產生以下輸出
{
"_id" : ObjectId("5ca2071d66324ffac2a7dc60"),
"CustomerName" : "Carol",
"ShippingDate" : "2019-01-21"
}
{
"_id" : ObjectId("5ca2073566324ffac2a7dc61"),
"CustomerName" : "Bob",
"ShippingDate" : "2019-02-24"
}
{
"_id" : ObjectId("5ca2074266324ffac2a7dc62"),
"CustomerName" : "Chris",
"ShippingDate" : "2019-04-01"
}以下是將 String 轉換為日期資料型別的查詢
> db.stringToDateDataTypeDemo.find().forEach(function(data){
... data.ShippingDate= ISODate(data.ShippingDate);
... db.stringToDateDataTypeDemo.save(data);
... });讓我們再次顯示所有文件，以檢查字串是否已轉換為日期資料型別。以下為查詢
> db.stringToDateDataTypeDemo.find().pretty();
這將產生以下輸出
{
"_id" : ObjectId("5ca2071d66324ffac2a7dc60"),
"CustomerName" : "Carol",
"ShippingDate" : ISODate("2019-01-21T00:00:00Z")
}
{
"_id" : ObjectId("5ca2073566324ffac2a7dc61"),
"CustomerName" : "Bob",
"ShippingDate" : ISODate("2019-02-24T00:00:00Z")
}
{
"_id" : ObjectId("5ca2074266324ffac2a7dc62"),
"CustomerName" : "Chris",
"ShippingDate" : ISODate("2019-04-01T00:00:00Z")
}
更新日期：30-Jul-2019
707 次瀏覽
廣告