A timestamp is the time at which an event is recorded by a computer system. The timestamp term may also refer to Unix Time or to the timestamp data type.

0
votes
3answers
23 views

ext4 copy file to directory without changing directory timestamp

I'd like to copy a file to a directory without changing the modification timestamp of the directory on an ext4 filesytem. Well, many files and many directories in a script.I've looked at rsync and ...
-1
votes
6answers
38 views

How to convert date part of datetime to timestamp in PHP?

How can I just convert date part of datetime to timestamp?For example in this datetime: 2018-02-26 20:30:00I want timestamp of 2018-02-26 00:00:00.
1
vote
2answers
36 views

Convert time column in character format to manipulable time format in R

My question is about the standardization of column b. I need these data to be in a format that makes it easier to construct graphics.a<- c("Jackson Brice / The Shocker","Flash Thompson", "Mr. ...
-3
votes
1answer
30 views

want to convert timestamp to date and filter data month wise in laravel

i have date as a timestamp in database and i want to convert timestamp into date while fetching data from database, after that want to filter data according to current month wise.I'm new laravel
0
votes
1answer
34 views

Compare two timestamps in MySQL

I want to search a table if there which is invalid.I tried this but it didn't work.DELETE FROM sessions WHERE validuntil < CURRENT_TIMESTAMPHow can I do that and still use timestamps?
0
votes
1answer
31 views

Passing python list of dates to sql query where clause

I have a date column in the data frame which I convert to a list of dates begdtlist=df["BEG_DT"].tolist()print(begdtlist) returns following. Timestamp('2018-04-29 00:00:00'), Timestamp('2018-...
0
votes
1answer
25 views

PGAdmin / Postgres : Cannot write Timestamp data to Postgres (2018-04-18 05:40:28)

When I try to write the following date time format to Postgres using Pgadmin2018-04-18 05:40:28I get the following error. ERROR: invalid input syntax for type timestamp: "2018-04-18 05:40:28"...
0
votes
2answers
37 views

Convert column with minutes and seconds in seconds only in R

my dataframe have this format:name <- c("Carlos", "Matthew", "Toth", "Mike", "Joseph", "Andrey")time <- c("79:45","78","74:45","65:30","64","57")myexample <- cbind.data.frame(name, time)...
0
votes
1answer
15 views

How to convert a timezone offset value such as “-0400” to one that has a colon like “-04:00” in MySQL?

So I have a MySQL 5.7 database that is storing a UTC timestamp as well as the timezone offset in two separate columns. Timezone is in timezone and offset is in offset.From what I understand I can ...
1
vote
3answers
31 views

TimeUnit conversion from Milliseconds to Days not working for me

I'm trying to get the difference of two timestamps in days, and TimeUnit is returning completely incorrect results for me.Here is my code:long ts=1522242239952L;long now=1527274162820L;long ...
1
vote
2answers
34 views

Data Comparison in Python Pandas Series

That are 2 Data Series that i wish to compare based on a third.data_SKU1:SKU Weight1 1234 201235 30111 40101 23data_SKU2:SKU Weight21234 221235 35111 ...
1
vote
2answers
50 views

How to merge multiple text files in R when data-structure varies?

I am trying to merge multiple text files in one data file, but the first few lines and the last couple of lines don't have the same data-structure as the rest of my file. I want to combine multiple ...
0
votes
1answer
13 views

SQL timeStamp format is different on windows and ubuntu

I have a db in mysql in which one column is of timstamp datatype.It stores timstamp in this format yyyy-mm-dd hh-mm-sson both windows and linux.But when i am fetching data from mysql from my java ...
0
votes
1answer
9 views

ripple RPC method account_tx 'date' attribute issue

The Ripple RPC method account_tx retrieves a list of transactions that involved the specified account.While using account_tx it returns the date attribute as - 'date': 580452520i.e. in the ...
-2
votes
2answers
34 views

How to fetch only date from timestamp through PHP?

I want to fetch old date as well not only current date stored in Timestamp,i used date() function but it only return current date and time.

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,