Stack Overflow
Stack Overflow

Questions tagged [datestamp]

86 questions
0
votes
1 answer

supplied argument is not a valid MySQL result

I've got a PHP warning in my web app. I'm a bit of a noob. I want to add a timezone offset to the 'updated' timestamp based on the 'adjusttimezone' integer in each user's profile? This is the code: $timezonequery = mysql_query('SELECT adjusttimezone…
KemanoThief
  • 617
  • 8
  • 23
0
votes
0 answers

Static date and time stamp VBA

I have the following code in a module for a date and time stamp but when I open the spreadsheet each day, the spreadsheet is restamping and putting the present date and time from today instead of yesterday. Does anyone know if I'm missing something…
rwc14
  • 11
  • 5
0
votes
0 answers

How to subtract two datestamps from different dataframes with different indexes?

I detected peaks in an ECG signal and a blood pressure signal. And now I like to know the time difference between these two peaks. So I created two different dataframes with the timestamps of the peaks. How to subtract them from each other when…
NienkeL
  • 1
  • 1
0
votes
2 answers

Keeping track of "No Shows" on roster

Currently I am making a schedule of class times where the secretary adds names to the list for however many seats are available for that room, and it shows whether or not they have passed the test already. The managers would like a count of how many…
deltas2k
  • 3
  • 5
0
votes
0 answers

Is there a way to read multiple excel files into R, but only up to a certain creation date? (Note: Date does not exist within the actual excel files.)

I have multiple excel files in multiple directories that I am reading into R. However, I don't want to read in EVERY excel file; I only want to read in the most recent ones (for example, only the ones created in the last month). Is there a way to do…
Kylie Baer
  • 31
  • 2
0
votes
0 answers

Comparing two rows with array formula to indentify differences and return "Last Change Date"

I currently have an Excel Table which is edited by multiple users. I wrote some formula to compare the actual status with the last saved file. It works well, but as any array formula, it is extremely slow: Macro copies all entries when I open the…
t.novaes
  • 126
  • 2
0
votes
1 answer

Transform datetime to timestamp python

I need your help. I have parsed a web site, and I have harvested this: 2018-08-18T23:31:00 I searched, but couldn't find how to change datetime to timestamp Example of my desired result : 1535414693077
sapiron
  • 93
  • 2
  • 7
0
votes
2 answers

Convert date with full month name and time to ISO date

I have a date and time stamp in the format 02 December 2016 18:00pm. This is generated by jQuery selector: "datestamp": $('span.article_info__published').text(), How can I convert it to the format 2007-07-24T12:50:00+01:00? If possible, I'd like to…
Robert Andrews
  • 1,209
  • 4
  • 23
  • 47
0
votes
1 answer

Very long datestamp format

Need to parse logs with datestamp in format longer than traditional Unix timestamp localTime="636597250599883050" utcTime="636597142599883050" Regualar Unix timestamp to compare time.time() 1525193621.900381 …
sergeyvin
  • 23
  • 1
  • 7
0
votes
1 answer

MySQL dual datestamp for modified, and updated does not work

I am trying the following SQL statement: create table sample ( id int not null primary key auto_increment, name varchar(100), date_modified timestamp not null default current_timestamp on update current_timestamp, date_created timestamp not null…
kkr16
  • 3
  • 1
0
votes
1 answer

JavaScript mail function - strip datestamp portion from string

I am working with Google apps script and have a working function that sends emails based on a custom menu. The function that sends them is using a getRowsData() function to gather all the columns as objects, concatenating those objects into strings,…
Jensen010
  • 445
  • 6
  • 18
0
votes
1 answer

Cron job doing MySQL database back up not working when append date to the file name

I'm using shared cPanel hosting. When I enter the following cron job command it works: */5 * * * * /usr/bin/mysqldump -u user -p'pazzword' my_db > /backup/database.sql But when I try to add date stamp to the file name, it doesn't generate…
Атанас Атанасов
  • 214
  • 2
  • 13
0
votes
0 answers

Adding seconds to ISO 8601 datestamp string

I am trying to add seconds to a datestamp string that is received from a json object but the datetime function I am trying to use does not allow strings and wants the date to be separated like: datetime.strftime(2011,11,18). Here is what I…
Demetrius
  • 449
  • 1
  • 9
  • 20
0
votes
2 answers

Open files older than 3 days of date stamp in file name - Python 2.7

** Problem ** I'm trying to open (in python) files older than 3 days of the date stamp which is in the current name. Example: 2016_08_18_23_10_00 - JPN - MLB - Mickeymouse v Burgerface.ply. So far I can create a date variable, however I do not know…
user6705306
  • 117
  • 13
0
votes
4 answers

Find and adjust date and timestamp in XML using python

I'm trying to change all date values in an XML and subsequently add or subtract an user specified amount of time from the time stamps. The timestamps are all of the format 2016-06-29T17:03:39.000Z However, they are not all enclosed in the same…
Max_the_Roos
  • 1
  • 1
1 2 3
4
5 6