Questions tagged as 'datetime'

Tagged questions
1
answer

Concatenate date and time in a variable

I need to create a complete date with date and time, I have two functions that receive a date and another time and I want to concatenate them to show the following format: yyyy-MM-dd HH:mm:ss dateChange(selectedDate) { //console.log...
asked by 17.10.2018 / 13:40
1
answer

Failed to move from one Array of string to another of Dates C #

The error gives me inside the loop for , I need the date to enter the format of "days / months / years hours: minutes". protected void Page_Load(object sender, EventArgs e) { string strfechas = Request.QueryString["date"]; char...
asked by 10.10.2018 / 12:29
0
answers

Highcharts export dateformat

Using highcharts v6.1.4 I can export without problems but I can not find a way to format the date that I transfer to my cvs, xls and table, they appear in format with unixtime example numbers: 1538917920000;19,3 1538917980000;19,5 153891804000...
asked by 08.10.2018 / 18:37
1
answer

Change the date format from Epoch to datetime in PowerShell

I have a String that represents a time in Epoch and I need the correct format to be able to enter it into a SQL Server database, from PowerShell. So far I can change the Epoch format to a very long date format, EXAMPLE: Date in Epoch to conve...
asked by 10.10.2018 / 19:23
0
answers

string to date pandas ex

I have a problem with data conversion. With the strtime function I convert the string into the date format I want and write it in an EXCEL cell. When I open EXCEL, it detects the format (through the EXCEL cell format menu) but not quite ... beca...
asked by 23.09.2018 / 08:40
1
answer

Operations with dates

I have a DataFrame ( df ), in which the dates are in the format datetime64(ns) (2017-09-18). I need to implement the following statement in a Python script: Fech_Act = pd.Timestamp("2018-08-02") df["TAE"] = ((1 +((df["Val_Act"]/d...
asked by 09.08.2018 / 23:46
1
answer

Create conditional comparing current date with registration date

I need help with conditionals using dates .. I need when creating a record the cell of the table is colored verde , By passing 3 days after the record was created, the cell is automatically naranja and when going...
asked by 11.08.2018 / 19:54
1
answer

"echo" the date if it is different from the previous one

The whole problem is for a chat. I have a echo , within a foreach , and for each message, get the complete date: Example: Sat, 21 of July 2018 and I want to know how to put a check to see if the following message has the sa...
asked by 22.07.2018 / 00:50
1
answer

Detect date change using datetime

I'm looking for a way to make an "Automatic Money Adder"; for example; I get up one day, I turn on the pc and automatically add $ 10 to a file. My problem is part of a code to determine that today is not the same as yesterday and do not add it...
asked by 24.06.2018 / 07:24
0
answers

Illegal hour value '58' for java.sql.Time type in value

I have a doubt with this problem apparently when doing the select and doing the operation with the method TIMESTAMPDIFF of MySQL I get the following error: java.sql.SQLException: java.sql.SQLException: Illegal hour value '58'...
asked by 04.05.2018 / 10:18