[02:11:09] <iio7> Doing a "date" on the console, I get "lør okt 10 04:04:36 CEST 2015", but doing a "new Date()" on mongodb, I get "ISODate("2015-10-10T02:04:45.142Z")", why is it off by 2 hours?
[02:11:58] <iio7> Using "new MongoDate()" creates wrong timestamps like that.
[02:18:47] <iio7> Can correct timezone not be set in configuration?
[02:19:29] <cheeser> you can pass TZ in the string
[02:23:34] <Boomtime> iio7: the datetimes you provided are the same - CEST is 2 hours ahead of UTC, the ISODate is always shown in zulu time because it doesn't know what timezone you want
[02:24:11] <Boomtime> bottomline, the timestamps are correct, there is nothing to fix
[02:24:17] <iio7> Hmm, but should that not be configurable?
[02:24:50] <Boomtime> you can put in a feature request if you like - to be able to get the shell to print out timestamps in your configured timezone, but it's entirely cosmetic
[02:27:59] <iio7> Yes, but if it isn't possible to configure, one has to convert back and forth all the time. Maybe it's because I am used to how MySQL deals with local time.
[02:28:28] <Boomtime> convert back and forth? are you using the shell as a UI or something?
[02:29:06] <Boomtime> the data has not changed, the issue you are experiencing is a display issue, the shell is not _displaying_ the date the way you want, it has not changed anything
[02:29:11] <iio7> No, I was testing using the shell because the PHP script was giving back wrong times. So I checked using the console.
[02:29:25] <Boomtime> then your php script is wrong
[02:29:51] <cheeser> you *think* you want to store the TZ but you almost certainly don't.
[02:30:06] <cheeser> normalizing to UTC makes querying way more efficient.
[02:30:17] <iio7> No, it is not. PHP is set to recognize and use the local timezone, but when time is store in MongoDB, it is in UTF, so one has to convert back and forth. I cannot have my script display time in UTC.
[02:30:51] <Boomtime> you should be dealing with UTC everywhere, only in the UI itself should you ever print as something else
[02:31:03] <Boomtime> doing it any other way _will_ cause you severe problems
[02:31:07] <Boomtime> and this is where you are now
[02:31:12] <iio7> But when I use "new MongoDate" it stores in UTC, so when I fetch I need to convert it right?
[02:31:16] <cheeser> every ... wait for it ... *time*
[03:41:02] <androidbruce> hey all, my localdb is gorwin large
[03:41:18] <androidbruce> and well the people who provisioned these instances created a very small "/"
[03:41:36] <androidbruce> is there an option to change the location of the localdb?
[04:53:36] <SAiF> hi all, I was trying to create an admin user in mongo and now i cant login with --auth, it says authentication failed. I am new to mongo.
[04:54:29] <SAiF> I have reinstalled the mongodb but still its asking for authentication ..
[04:54:59] <SAiF> which files should I delete to completely reinstall mongodb.. In windows
[06:01:19] <SAiF> cant use userAdminAnyDatabase , no role named useradminanydatabase@admin.. ???
[06:01:31] <SAiF> how can i create a admin user???
[06:02:22] <SAiF> is there any other channel for mongodb ?
[10:07:31] <ax003d> Why my replica set node never sync?
[10:07:33] <ax003d> syncedTo: Thu Jan 01 1970 08:00:00 GMT+0800 (CST)
[10:07:33] <ax003d> 1444471326 secs (401242.04 hrs) behind the primary
[11:17:45] <zcserei> Hi! How can I check if a certain model is empty? I'm using mongodb, and I want to create a sample user if the User model has no users yet.
[19:56:27] <raazdaan> hey does anyone know how well mongodb's full text search works these days? the only articles i'm pulling are from 2014
[23:42:45] <kevrr> would be spidermonkey the javascript engine of mongodb again?
[23:47:14] <nalum> I'm having an issue with pymongo 3.0.3 where the returned cursor is throwing an exception about a unicode string, can anyone help me figure out the issue or point me in the right direction?