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
4
votes
2 answers
write.csv in R is converting my dates into a 10 digit integer
In Excel, I created a Year End Date column of 1000 rows, where every cell's contents are 12/31/2018. I formatted this as a Date in Excel. I pulled this all into R, did some data manipulation on other columns, NOT the date column, and exported the…
Misc
- 41
- 1
- 2
4
votes
5 answers
How to convert local date to UTC in Mirth?
In Mirth I receive a local datetime string (201801011000) which I need to convert to UTC. I soon found out using the classic js new Date() doesn't work well.
This for example:
var d = new Date("2018-01-01 10:00");
logger.info(d.toString());
gives…
kramer65
- 50,427
- 120
- 308
- 488
4
votes
1 answer
Convert datestring to date() in qml
i need to convert date string "28/01/2018" (dd/mm/yyyy) into a Date() in qml.
i'm tried this:
var dateBoard = masterPAGEMAIN.getData();
var locale = Qt.locale()
var someDateTest = new Date()
someDateTest = Date.fromLocaleString(locale,…
Mr. Developer
- 3,295
- 7
- 43
- 110
4
votes
1 answer
How to to convert from ldap time format to js date format?
I want to read a time stamp from Active Directory and compare it to an other date created in JS.
From AD I'm getting the date in form of an 18-digit number (time in 100 nanoseconds since Jan 1, 1601 UTC). JavaScript uses date numbers in form of a…
Kinaeh
- 277
- 6
- 16
4
votes
1 answer
PHP timezone conversion issue
I have this function which is used to covert request date into GMT00 unix time span and store that time span into database.
When i am trying to convert GMT00 time span to valid GMT timezone like GMT+4:00 then below function return wrong time…
Parth Nayak
- 41
- 4
- 7
4
votes
2 answers
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,'YYYY-MM-DD HH24:MI:SS.FF'),'YYYY-MM-DD HH24:MI:SS'))
from S_TIDAL_STATUS
The error was:
ORA-01830: date format picture…
Anna Huang
- 287
- 2
- 5
- 15
4
votes
1 answer
Is there a faster date conversion than pd.to_datetime?
I'm trying to convert dates in a pandas dataframe in the format 01/01/2017 to a python format in order to extract the day of the week.
I've been using:
df['Date'] = pd.to_datetime(df['Date'])
df['DOW'] = df['Date'].dt.weekday_name
but the first…
kozowh
- 93
- 2
- 10
4
votes
1 answer
Is it safe to transform dates back and forth using UTC in order to ignore DST but still using a valid locale for the current user?
I have a date (no time, assuming time 00:00:00) that I convert between a time_t and a struct tm.
I get a date in the simple YYYYMMDD format and convert that to a struct tm:
struct tm my_tm;
memset(&my_tm, 0, sizeof(my_tm));
my_tm.tm_year =…
Alexis Wilke
- 19,179
- 10
- 84
- 156
4
votes
2 answers
While converting String to Date got ambiguity between java.util.Date and java.sql.Date
I am trying to get date as input from Date tag of HTML
Birth Date
and accessing on jsp page by using
String strDate = request.getParameter("dob");
but it returns in the format of string and I wanted to convert it in…
Atish Kumbhar
- 579
- 1
- 8
- 21
4
votes
2 answers
Using javascript's date.toISOString and ignore timezone
I want to use the javascript's toISOString() function and ignore the timezone.
var someDate; // contains "Tue May 26 2015 14:00:00 GMT+0100 (Hora de Verão de GMT)"
dateIWant = someDate.toISOString(); // turns out "2015-05-26T13:00:00.000Z"
The date…
chiapa
- 4,362
- 11
- 66
- 106
4
votes
4 answers
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 applied to the input text box. On submit, I want the date to be passed to the server in yyyymmdd format say 20141209. So how to convert…
kumareloaded
- 3,882
- 14
- 41
- 58
4
votes
1 answer
Moment.js timezone conversion C# .NET
Is there an available c# plugin that handles all the moment.js timezones.
I am having a hard time comparing the dates in the backend since the timezones from moment.js is not the same as the timezones from the .net DateTime.
I need to convert the…
Milo Cabs
- 503
- 1
- 10
- 24
4
votes
3 answers
In Oracle, why does this return March 1st?
In Oracle, this returns 03/01/2010. That does not make sense to me. Anybody know why?
SELECT TO_DATE( '2010' ,'yyyy' ) AS STRANGE_YEAR_RESULT
FROM DUAL
I've tried on Oracle 10g and 11g.
JosephStyons
- 57,317
- 63
- 160
- 234
4
votes
2 answers
shamsi / Jalali Calender in Android with string parameters
i'm using this algorithm for changing Calender date to Persian calender.
here
it's work fine but:
when i want to create a new constructor for getting parameters and change a String to Persian date, like change "2012/3/6" to Persian (instead of…
Mahdi
- 6,139
- 9
- 57
- 109
4
votes
3 answers
Convert "YYYYMMDD" format string to date in MDX?
I have some issue with applying date related functions on the "YYYYMMDD" format string in MDX. For example, if I have this query below:
with
member foo as WEEKDay("2013-03-21")
select
foo on 0
from
[Some Cube]
It will correctly output…
bigbearzhu
- 2,381
- 6
- 29
- 44