Top "Date-conversion" questions

Conversion of dates from one calendar or notation to another, for example, converting Julian calendar February 29, 1700 to Gregorian calendar March 11, 1700, or "March 11, 1700" to "1700-03-11".

In SQL Server, how to convert a date to a string in format M/D/YYYY? (no leading zeros, not MM/DD/YYYY)

Right now, my code has the following conversion for a date field: convert(varchar, Citation.PublishedOn, 101) However, that returns dates …

sql-server sql-server-2008 date-formatting date-conversion
javascript - regular expression to validate date in mm/dd/yyyy format

I'm not good at regular expression. I got code to validate dd/mm/yyyy format which also validates leap year, …

javascript regex validation date date-conversion
Converting Gregorian date to Hijri date

How do you convert Gregorian dates to Islamic Hijri dates using JavaScript?

javascript date gregorian-calendar date-conversion hijri
PL SQL - Convert timestamp to datetime/date

select to_timestamp(SCHEDULED_TIME,'YYYY-MM-DD HH24:MI:SS.FF') as SCHEDULED_TIME, TRUNC(to_date(to_timestamp(SCHEDULED_TIME,…

sql oracle plsql timestamp date-conversion
MYSQL: How to convert a string into a month (Number)

I have the short version of months: JAN, FEB, MAR, etc. and would like to convert them to it's respective …

mysql string-conversion date-conversion
How to split minutes into days, hours and minutes in tsql

I have a column which consist of minutes. Is there any simple way to split minutes column into one column …

sql-server tsql datetime date-conversion
ORA-00932: inconsistent datatypes: expected NUMBER got DATE in oracle stored procedure

I have below query which i am using in oracle stored procedure where i am getting error as ORA-00932: inconsistent …

oracle stored-procedures date-conversion
convert string into java.util.date format in java

am having a string like this. Thu Oct 07 11:31:50 IST 2010 I want to convert this into its exact date time format …

java string datetime date date-conversion
Convert Between Datetime Formats Using Perl

We're currently using a 3rd party API that provides datetime in the following format: Sat Mar 06 09:00:00 ICST 2010 Fri Feb 19 19:30:00 JDT 2010 …

mysql perl datetime date-conversion
How to convert date format from dd-MMM-yyyy to yyyymmdd in Javascript?

I've an input text box with a date-picker, when the user selects a particular date, the date say 09-Dec-2014 gets …

javascript date date-formatting date-conversion