Stack Overflow
Stack Overflow

Questions tagged [datestamp]

86 questions
221
votes
7 answers

Select records from NOW() -1 Day

Is there a way in a MySQL statement to order records (through a date stamp) by >= NOW() -1 so all records from the day before today to the future are selected?
user1092780
  • 2,291
  • 3
  • 15
  • 10
19
votes
3 answers

Ignoring date column in beyond compare file comparison

I'm using BeyondCompare3 i've two files with lines containing with this kind of format. abc,bbbb,cdef,test,14:45:23.123,info,comment I want to omit the date from the comparison. I've selected Session > Session Settings > Importance Tab > Edit…
John
  • 787
  • 4
  • 11
  • 28
13
votes
5 answers

Generate a current datestamp in Java

What is the best way to generate a current datestamp in Java? YYYY-MM-DD:hh-mm-ss
Trastle
  • 5,155
  • 6
  • 26
  • 20
7
votes
2 answers

Two sql for Sorted timestamp date

I have 98w rows data. When I want sort my data with pub_time, I found an interest thing. Here is the SQL: select * from t_p_blog_article_info t order by t.pub_time desc It cost 19s. select * from t_p_blog_article_info t where t.pub_time >…
sarowlwp
  • 105
  • 1
  • 11
4
votes
4 answers

Quickly determining if a folder contents have been modified

I need to determine which folders contain files that have been modified "recently" (within a certain interval). I notice that folder datestamps seem to get updated whenever a contained file is modified, but this behaviour doesn't propagate up the…
rossmcm
  • 5,493
  • 10
  • 55
  • 118
4
votes
3 answers

Difference between 2 dates in minutes excluding weekends and holidays

I'm relative new to PHP programming and run into an interesting problem. I've tried multiple searches and found different solutions, but none of them fit my precise problem. I have 2 datestamps in mysql format (2014-04-10 09:00:00 for example). I…
HenkB
  • 43
  • 1
  • 4
3
votes
2 answers

Create a new datestamp every time a certain cell changes?

I have a cell that states the status of a project, and this status will change frequently. Whenever the status gets changed, I would like a row to state the time the status was changed and the name of the new status. I have next to no experience…
user1556274
  • 37
  • 4
3
votes
1 answer

Generating time series reports

I'm trying to work out how to create a solution that will allow me to query a table that has a timestamp, and in return get a time series data. The request consists of start/end date & time, granularity type (minute, hour, day, week, month and year)…
Daniel Protopopov
  • 6,778
  • 3
  • 23
  • 39
2
votes
3 answers

MySQL table modified timestamp

I have a test server that uses data from a test database. When I'm done testing, it gets moved to the live database. The problem is, I have other projects that rely on the data now in production, so I have to run a script that grabs the data from…
Anthony
  • 36,459
  • 25
  • 97
  • 163
2
votes
2 answers

Need to do a math operation on every line in several CSV files in Python

I have about 100 CSV files I have to operate on once a month and I was trying to wrap my head around this but I'm running into a wall. I'm starting to understand some things about Python, but combining several things is still giving me issues, so I…
mrmylanman
  • 23
  • 1
  • 4
2
votes
3 answers

Perl and epoch time question

How can I take the current epoch time from perl and find the epoch time from 6 months ago? I need to compare the create date of a file to see if it 6 months or older.
AtomicPorkchop
  • 2,625
  • 5
  • 36
  • 55
2
votes
1 answer

Timestamp in Hibernate

I'm quite fresh in Hibernate, I just have run my first project with Hibernate. But I want to insert some data in my Postgres DB, one of the column is operationtime TIMESTAMP WITH TIME ZONE , while I was doing this with Postgres I was using…
Brake
  • 21
  • 1
  • 2
2
votes
1 answer

Worksheet_Change Sub slow autocalculation

I have a very complex Excel file that should have been replaced with a database a looong time ago, however it is not possible at the time. There is a need to implement a way to record when a change was made to a certain columns and record the date…
mozgov_net
  • 317
  • 2
  • 12
2
votes
2 answers

How to do a date stamp in CakePHP

I'm doing an enquiry system and I want every enquiry created to have a date stamp (not time). Just wondering how I would go about doing this. I'm guessing I'd start with grabbing the current date, then saving the data? Sorry I'm new to this :/
user2687801
  • 21
  • 2
2
votes
2 answers

Creating a text file with a timestamp in the title

I'm trying to write a program which outputs a lot of data in separate text files. I want the title of each file to be Poker_Log_timestamp_datestamp.txt However, it doesn't actually create the file, nor does it throw any errors! Here's the…
Magicaxis
  • 371
  • 7
  • 16
1
2 3 4 5 6