Top "Datetime" questions

Should I use the datetime or timestamp data type in MySQL?

Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I'm working with PHP on the …

mysql datetime timestamp sqldatatypes

Converting string to Date and DateTime

If I have a PHP string in the format of mm-dd-YYYY (for example, 10-16-2003), how do I properly convert …

php string datetime date

How to remove time portion of date in C# in DateTime object only?

I need to remove time portion of date time or probably have the date in following format in object form …

c# datetime

How can I select the first day of a month in SQL?

I just need to select the first day of the month of a given datetime variable. I know it's quite …

sql sql-server tsql sql-server-2008 datetime

Format date and time in a Windows batch script

In a Windows (Windows XP) batch script I need to format the current date and time for later use in …

windows datetime formatting batch-file

How to calculate the difference between two dates using PHP?

I have two dates of the form: Start Date: 2007-03-24 End Date: 2009-06-26 Now I need to find …

php datetime datediff

How do you get the current time of day?

How do you get the current time (not date AND time)? Example: 5:42:12 PM

c# datetime

Finding the number of days between two dates

How to find number of days between two dates using PHP?

php datetime

How to get Time from DateTime format in SQL?

I want to get only Time from DateTime column using SQL query using SQL Server 2005 and 2008 Default output: AttDate == 2011-02…

sql-server tsql sql-server-2005 datetime

Get current time in milliseconds in Python?

How can I get the current time in milliseconds in Python?

python datetime time