The number of seconds between a particular date and the Unix Epoch on January 1st, 1970
0
votes
1answer
9 views
Get entries between one date and another via a unix timestamp
If I have a column in a table called creation_date in the database that contain unix timestamp values, how do I get results returned that were only created between for example May 10th 2013 and June ...
0
votes
0answers
21 views
Insert the to_timestamp and NLS_LANGUAGE through unix shell
I've got this timestamp field:
if [ "${arr[1]}" != "NUMBER" ];
then
fieldtmst=`echo $var |
awk 'BEGIN { f="'"'"'" }
{
split($0,x,/@#/);
...
0
votes
1answer
35 views
Can someone explain session table laravel
Ok so I want to check if my users are online or not, I think a good way of doing this is using the sessions table that laravel provides. I'm a newbie though so can anybody first of all explain to me ...
-1
votes
1answer
44 views
Convert unix timestamp column to day of week in R
I am working with a data frame in R labeled "mydata". The first column, labled "ts" contains unix timestamp fields. I'd like to convert these fields to days of the week.
I've tried using strptime and ...
0
votes
1answer
67 views
python get time stamp on file in mm/dd/yyyy format
I'm trying to get the datestamp on the file in mm/dd/yyyy format
time.ctime(os.path.getmtime(file))
gives me detailed time stamp Fri Jun 07 16:54:31 2013
How can I display the output as 06/07/2013
...
0
votes
0answers
13 views
How to convert Iso Date to UTC date in hive
I have a Json data as below ,I need to convert that date or mongo_date into utc time >stamp.to analyse the data in hive as per timeline example per year ,per month,per week >using map reduce
{
...
1
vote
2answers
30 views
Date time conversion from timezone to timezone in sql server
I having an column of UNIX time stamp in my database table, which comes from a system that is in the Kuwait time zone.
My database server's time zone is Eastern Time US & Canada. Now I need to ...
3
votes
2answers
31 views
Formatting the date in unix/linux
I would like unix's date's day of the month format to be in the format 1 or 2 etc. instead of 01, 02. Is there anyway to achieve this?
For example
date +"%h%d%H:%M" yields Jun0100:30
ps. The ...
2
votes
0answers
13 views
In my database, how do I properly store days in unixtime for all timezones to work properly?
Let's say I want to store a data of how much people weight on each day, like this:
id | user | date | weight
1 1 2013-05-04 140
2 5 2013-05-08 160
3 120 2013-05-12 ...
0
votes
1answer
46 views
rendering Highcharts datatimes on the x axis at regular intervals
I have two arrays full of data. One array is just random integers (e.g. 1.7, 2.8, 3.4, etc.) and the other array is a corresponding list of unix timestamps for that data, (e.g. 1366585199).
At the ...
-1
votes
1answer
36 views
insert seperate date and time into one timestamp field
I am trying to insert a separate date field, and a separate time field from a php form, and insert it into my database, in on field. the inserted value must be as a unix timestamp. The date field uses ...
-1
votes
3answers
32 views
One timestamp with multiple formatting outputs
I want to display two dates/times on my page
the server one, taken from the MySQL Server
the client one, taken from JavaScript
Since the output wasn't right, I started digging through my code and ...
1
vote
1answer
17 views
Convert timestamp (UTC?) to UNIX timestamp using JQuery
I'm pulling dates from a web service using JQuery and they look like this:
2013-05-20T23:59:59+01:00
Is there a quick way to convert this format to a UNIX timestamp using JQuery? So it looks like ...
0
votes
4answers
43 views
How can I get the date difference of a timestamp
I am trying to create a query that will limit insertion into a table based on the last time the poster sent data to the table.
For example if you posted data to the table then you are locked out of ...
-1
votes
3answers
24 views
Javascript's Date object weird behaviour
Im trying to create a Date() object from a date formatted dd/mm/yyyy and sometimes it works and sometimes it's doesn't. For example:
new Date('12/05/2008 00:00:00'); //OK
new Date('13/05/2008 ...
android