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".
Questions tagged [date-conversion]
688 questions
-2
votes
4 answers
R convert character "111213" into proper time which is "11:12:13"
R convert character "111213" into time "11:12:13".
strptime("111213", format="%H%m%s") gives NA
and
strptime("111213", "%H%m%s") gives 1970-01-01 01:00:13 CET
Qbik
- 5,885
- 14
- 62
- 93
-2
votes
1 answer
How to convert a string (date formatted) to date time in Sqlite
I have a string column in my table and values are in "05/31/2016 10:03:24.175000000" this format. Need to convert this string value into DateTime through SQLite.
I am using below query to convert string to date time. It's working fine for the…
Umapathy S
- 220
- 2
- 17
-2
votes
1 answer
Convert string to date c#
I want to convert below string to Date type in c#,
"Q2(JUN)-2016"
to
Q2-2016 (which is of date type)
The result should be of date type and it should indicate quarter2.
Sparrow
- 355
- 4
- 19
-2
votes
1 answer
Date format conversion in Javasscript
In javascript, how to bring the date from the format (dd-mm-yy) and display it on the page as (dd-mm-yyyy)?
Ex: 10-Mar-15 to 10-Mar-2015
chat
- 1
-2
votes
1 answer
String was not recognized as a valid date - VB.NET
In my SSIS project I have a date variable of type [DT_DATE]
I'm trying to convert rows which contains a string (a date and a time)
The format of the string looks like this: 20151107 19:32:23
I want to convert this into a datetime format before I…
Nilzone-
- 2,766
- 6
- 35
- 71
-2
votes
2 answers
Convert string date with mixed format to epoch
I have list of dates which has mixed format like:
01-01-13
01-12-13
1/19/2013
1/21/2013
1/21/2013
1/30/2013
02-01-13
02-02-13
02-12-13
2/13/2013
2/23/2013
...
I want to convert that list into list of epoch (to keep it in SQLite db on Android). So…
Marian Paździoch
- 8,813
- 10
- 58
- 103
-2
votes
1 answer
MongoDb Date conversion
I have a large query running on a collection pulling back the date in NumberLong format, I then export to a .csv where I run a formula to convert the date to a format a human can use. Scrolling the web I am not able to find a clear way of pulling…
-2
votes
2 answers
Convert seconds into years, months, weeks, hours, minutes and seconds
I'm struggling to find a solution as to converting seconds into years, months, weeks, hours, minutes, seconds.
Example:
public Time(int inputSeconds) {
int years = 0;
int months = 0;
int weeks = 0;
int days = 0;
int hours = 0;
…
Faris Rehman
- 129
- 1
- 4
- 11
-2
votes
4 answers
Date formatting with Century
I there a way to format dates which contain century in it to common format.
Format date in cyymmdd to MM/dd/yyyy.
Example,
Convert 1140711 to o7/11/2014
user630209
- 1,123
- 4
- 42
- 93
-2
votes
4 answers
PHP - convert yyyy-mm-dd to Month, Year format i.e, ( 2013-01-12 to Jan 2013 )
I get the date in the variable date as
$date = "dob;?>" ; //where let dob=2013-01-12
I want to convert this into Jan 2013 format. How to convert in php?
user3702622
- 21
- 3
- 8
-2
votes
2 answers
break d date from yyyy-mm-dd into mm,yyyy and dd as separate elements
I am storing the date in MySQL in the format yyyy-mm-dd. I wish to extract individual elements of the date i.e. day,month and year as separate elements
How should I go about this?
I am using php
user2822187
- 307
- 2
- 11
- 26
-2
votes
5 answers
How to change the format of date in java
I have a string and i need to convert it to date in the "YYYY-mm-dd" format which i'm unable to do. I checked the similar post on stckoverflow but didnt help so i'm posting this query.
String stringDate = "Dec 13, 2013";
I need this to be convert…
madhu
- 1,010
- 5
- 20
- 38
-2
votes
2 answers
Java date format conversion
date from database
2013-10-26T10:31:20GMT+05:30
UI Date
Mon Feb 10 00:00:00 GMT+05:30 2014
need to convert according to Database Date
Er KK Chopra
- 1,834
- 8
- 31
- 55
-2
votes
4 answers
PHP, convert many different date formats into day-month-year
Possible Duplicate:
how to convert php date formats to GMT and vice versa?
In PHP, I have a string date like this:
May 21, 2012 07:23:15 GMT
or this
21 May 2012 07:23:15 GMT
I need to convert both the strings into something like this:…
Dmitry Makovetskiyd
- 6,942
- 32
- 100
- 160
-3
votes
2 answers
php date conversion to date having time
I am trying to convert php date conversion like 09/30/2011 to this format 2011-09-30 21:35:46.
I read some manuals but its going to be difficult for me.
$input = "09/30/2011";
$output = "2011-09-30 21:35:46";
$output = date('Y-m-d h:m:s',…
Muhammad Imran Tariq
- 22,654
- 47
- 125
- 190