Top "Datetime" questions

Best approach to remove time part of datetime in SQL Server

Which method provides the best performance when removing the time portion from a datetime field in SQL Server? a) select …

sql sql-server tsql datetime date

How do I get the day of week given a date?

I want to find out the following: given a date (datetime object), what is the corresponding day of the week? …

python datetime weekday

Add default value of datetime field in SQL Server to a timestamp

I've got a table that collects forms submitted from our website, but for some reason, when they created the table, …

sql-server datetime

How to sort an array by a date property

Say I have an array of a few objects: var array = [{id: 1, date: Mar 12 2012 10:00:00 AM}, {id: 2, date: Mar 8 2012 08:00:00 AM}]; How …

javascript datetime

Get day of week in SQL Server 2005/2008

If I have a date 01/01/2009, I want to find out what day it was e.g. Monday, Tuesday, etc... Is …

sql sql-server datetime

Convert from MySQL datetime to another format with PHP

I have a datetime column in MySQL. How can I convert it to the display as mm/dd/yy H:…

php mysql datetime

How to convert DateTime to/from specific string format (both ways, e.g. given Format is "yyyyMMdd")?

I am having a problem converting a datetime which is in string format but I am not able to convert …

c# string datetime

String was not recognized as a valid DateTime " format dd/MM/yyyy"

I am trying to convert my string formatted value to date type with format dd/MM/yyyy. this.Text="22/11/2009"; DateTime …

c# .net datetime types casting

Convert UTC date time to local date time

From the server I get a datetime variable in this format: 6/29/2011 4:52:48 PM and it is in UTC time. I want …

javascript jquery datetime timezone utc

Find objects between two dates MongoDB

I've been playing around storing tweets inside mongodb, each object looks like this: { "_id" : ObjectId("4c02c58de500fe1be1000005"), "…

mongodb datetime twitter mongodb-query