Syntax error for inserting date but same works with mongodb command terminal

 

1. Execute the below query in a ADS Query Analyzer against a mongoDB Server and you get an invalid date error

2. Execute Query #2 against mongodb terminal which is the same query as in 1, but it executes fine without any error

 

Q #1

 

INSERT INTO jira_2 VALUES ( 

{ "version" : "1.6.3",

"uptime" : 4712,

"uptimeEstimate" : 3844,

"localTime" : Date( "Wed Oct 13 20:52:15 2010" )

}

)

 

 

Q #2

 

db.jira_2.insert( 

{ "version" : "1.6.3",

"uptime" : 4712,

"uptimeEstimate" : 3844,

"localTime" : Date( "Wed Oct 13 20:52:15 2010" )

}

)