2014/09/04 08:40 -0700, Jan Steinman
> From: "Ed Mierzwa (emierzwa)"
>
>
> FROM_UNIXTIME(1409304102.153) /*your epoch column here*/
I don't think the OP has a Unix timestamp.
The number looks suspeciously like concatenation of date digits, "140930" at
the beginning looks like Septem
- Original Message -
> From: "Jan Steinman"
> Subject: RE: converting numeric to date-time?
>
> I don't think the OP has a Unix timestamp.
OP explicitly says "epoch including milliseconds" - so it's going to be three
digits too long :-)
divide
> From: Jan Steinman
>To: mysql@lists.mysql.com
>Sent: Thursday, 4 September 2014, 16:40
>Subject: RE: converting numeric to date-time?
>
>
>> From: "Ed Mierzwa (emierzwa)"
>>
>>
>> FROM_UNIXTIME(1409304102.153)/*your epoch column
> From: "Ed Mierzwa (emierzwa)"
>
>
> FROM_UNIXTIME(1409304102.153) /*your epoch column here*/
I don't think the OP has a Unix timestamp.
The number looks suspeciously like concatenation of date digits, "140930" at
the beginning looks like September 30, 2014.
If that's the case, you need to
mber 01, 2014 5:51 PM
To: Rajeev Prasad
Cc: MYSQL General List
Subject: Re: converting numeric to date-time?
* Rajeev Prasad [2014-09-01 17:55]:
> I have a column in a table which is epoch time including milliseconds.
>
> e.g. = 1409304102153
>
>
> now i want to display all
* Rajeev Prasad [2014-09-01 17:55]:
> I have a column in a table which is epoch time including milliseconds.
>
> e.g. = 1409304102153
>
>
> now i want to display all fields in the table but this field as: "2014-8-29
> Fri 09:21:42: GMT" (whatever comes in )
>
>
> and i am not findi
I have a column in a table which is epoch time including milliseconds.
e.g. = 1409304102153
now i want to display all fields in the table but this field as: "2014-8-29 Fri
09:21:42: GMT" (whatever comes in )
and i am not finding anything on web about how to do that.
can anyone help
Quoting Machiel Richards :
We need to be able to delete all data from the 2 tables that is
older than the start of yesterday.
Hi,
I use this ver simple script to purge data from a syslog DB:
#!/usr/local/bin/bash
/usr/local/bin/mysql -u syslog -pmypasswd -e 'DELETE FROM Syst
A simple stored procedure run by the event scheduler at predetermined times
will do this quite easily. Can you post the output of SHOW CREATE TABLE for
your two tables?
John
On 23 May 2011 13:15, Machiel Richards wrote:
> Hi Everyone
>
>I have posted this question quite a while back and
Hi Everyone
I have posted this question quite a while back and noticed now
that I haven't gotten an answer as yet and this is still on my
unresolved list.
We have 2 tables which we want to archive data from.
We need to be able to delete all data from the 2 tables that is
TURN CONCAT( yy, ' years ', mm, ' months ', dd, ' days ', hh, '
>> hours ', mi, ' mins ', ss, ' secs' );
>>
>> END
>>
>> Maybe this will help.
>>
>> Thanks,
>>
>> Randall Price
>> Seni
gt;
>
>
> -----Original Message-
> From: Gavin Towey [mailto:gto...@ffn.com]
> Sent: Friday, March 05, 2010 4:15 PM
> To: Tompkins Neil; prabhat kumar
> Cc: [MySQL]
> Subject: RE: Displaying date/time
>
> That's probably something best done in your presentation (app) l
PM
To: Tompkins Neil; prabhat kumar
Cc: [MySQL]
Subject: RE: Displaying date/time
That's probably something best done in your presentation (app) layer.
If you must do this in mysql, then you'll probably want to write a stored
function.
-Original Message-
From: Tompkins Neil [mail
bhat kumar
Cc: [MySQL]
Subject: Re: Displaying date/time
Hi
That is kind of what I'm looking for. However I'd like to be able to
display the difference between date 1 and date 2 like
1d 2h 29min ago
Thanks
Neil
On Fri, Mar 5, 2010 at 3:32 PM, prabhat kumar wrote:
> Might be this
Hi
That is kind of what I'm looking for. However I'd like to be able to
display the difference between date 1 and date 2 like
1d 2h 29min ago
Thanks
Neil
On Fri, Mar 5, 2010 at 3:32 PM, prabhat kumar wrote:
> Might be this will help you:
> there is a table called message with 3 colums - id,
Might be this will help you:
there is a table called message with 3 colums - id, pubdate and message;
You can get all messages from the last 5 minutes with the following example;
SELECT TIMESTAMPDIFF(MINUTE, pubdate, now()), id, message from message where
(TIMESTAMPDIFF(MINUTE, pubdate, now()) < 5
Hi
I have a number of rows which have Date and Time data in. I want to display
in the following formats based on the systems current time
e.g under 1 hour 24min ago
e.g under 1 day 16h 29min ago
e.g over 1 day 1d 2h 29min ago
e.g over 1 week 1w 4d 2h 29min ago
How would this best be achieve usi
On Fri, May 22, 2009 at 12:42 PM, John Meyer wrote:
> Janek Bogucki wrote:
>>
>> Hi John,
>>
>> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes
>> some information about acceptable literal forms for dates and times.
>>
>> 'Thu May 21 03:15:28 + 2009' is not an acceptab
Janek Bogucki wrote:
Hi John,
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes
some information about acceptable literal forms for dates and times.
'Thu May 21 03:15:28 + 2009' is not an acceptable literal form but
this is how to parse it APART from the time zone com
nt donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> Date: Fri, 22 May 2009 07:14:58 -0600
> From: john.l.me...@gmail.com
> To: janek.bogu...@studylink.com
> CC: mysql@lists.mysql.com
>
Janek Bogucki wrote:
Hi John,
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes
some information about acceptable literal forms for dates and times.
'Thu May 21 03:15:28 + 2009' is not an acceptable literal form but
this is how to parse it APART from the time zone com
%Y'));
mysql> select * from t;
+-+
| d |
+-+
| 2009-05-21 03:15:28 |
+-+
1 row in set (0.01 sec)
On Thu, 2009-05-21 at 15:19 -0600, John Meyer wrote:
> Is "Thu May 21 03:15:28 + 2009" a valid date/time string?
>
Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> Date: Thu, 21 May 2009 15:19:16 -0600
> From: john.l.me...@gmail.com
> To: mysql@lists.mysql.com
> Subject: Date Time
>
> Is "
Is "Thu May 21 03:15:28 + 2009" a valid date/time string?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello guys,
I would like to get some registers on my database that are older than 90
days, and after delete it because the table is very larger:
mysql> select count(*) from max_ecardsent;
+--+
| count(*) |
+--+
| 1172330 |
+--+
1 row in set (0.01 sec)
But I'm confusing
I have data that is broken into anything from 30 sec to 15 minute time
series (with a DATETIME field). I need to transform all of this into 15
minute data. Does anyone know off the top of their head if there a way I
could use GROUP BY to make this happen? Nothing I have tried thus far
has worke
I have a timestamp stored in a datetime field. It gets set using Now()
when the record was inserted. I would like to pull the data back out
and have it in UTC time. Is there an easy way to do this? I've been
through the manual and on google but haven't come up with anything.
This is in a PHP sc
Hello.
You said that you had created a view, but you continued using Tab_A
instead of Tab_A_View in your next queries. Did you want to use view
Tab_A_View? On my MySQL 5.0.9 all queries works both with view and
original table. See:
mysql> desc Tab_A;
+++-
Hello everyone,
I cannot figure this out. I have a table like the following:
Tab_A
datetime_field datetime not null,
num_field bigint not null
I do a SELECT as follows:
Select datetime_field, num_field from Tab_A
where datetime_field='2005-03-10' and
num_field = 1234;
I return 2 ro
icketing ";
hans
Rhino wrote:
> - Original Message -
> From: "Hans Bernard" <[EMAIL PROTECTED]>
> To:
> Sent: Wednesday, April 06, 2005 6:06 AM
> Subject: DATE & TIME
>
> > Hello,
> >
> > i need to have the time in this output
- Original Message -
From: "Hans Bernard" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, April 06, 2005 6:06 AM
Subject: DATE & TIME
> Hello,
>
> i need to have the time in this output. in MySQL database
> phpmyadmin always puts -00-00
>
> i need i
On Wed, Apr 06, 2005 at 12:06:37PM +0200, Hans Bernard wrote:
> i need to have the time in this output. in MySQL database
> phpmyadmin always puts -00-00
>
> i need it to be like this
> 01-APR-2005 >> DD-MMM-
Use date_format(, "%d-%b-%Y %H:%m") in your SELECT?
bye,
-christian-
--
Hello,
i need to have the time in this output. in MySQL database
phpmyadmin always puts -00-00
i need it to be like this
01-APR-2005 >> DD-MMM-
the time needs to be like this
22:55 >> HH:MM
can somebody help
hans
--
MySQL General Mailing List
For list archives: http://lists.mysql.
Thanks to both of you, here is my string:
select * from test where date(now())=substring(date,1,10);
:)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[snip]
I have been trying to figure out a way to filter a date out of
timestamp to no success. How do I filter out specific critieria that
I need using now()?
[/snip]
http://www.mysql.com/substring
WHERE now() = substring(dateTimeColumnName, 1, 8)
should get it
--
MySQL General Mailing List
F
I have been trying to figure out a way to filter a date out of
timestamp to no success. How do I filter out specific critieria that
I need using now()?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Your tables aren't setup very well. You should google for
normalization and 'boyce codd normal form'
-Eric
On Sat, 16 Oct 2004 22:27:51 +0200, owca <[EMAIL PROTECTED]> wrote:
> I'm trying get current week, starting from monday to sunday:
>
> select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19,
I'm trying get current week, starting from monday to sunday:
select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19, g20, g21, g22, id
from tydzien where to_days(day) between
to_days(now())- mod(to_days(now()),7)+2 /*some parameter setting a starting
day*/ and
(to_days(now())- mod(to_days(now()),7)
]
www.nisc.cc
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 11, 2004 14:54
Subject: Re: Date/Time Difference Calculations
>
> I didn't see where these were 4.1+ func
.cc> Fax to:
Subject: Re: Date/Time Difference
Calculations
06/11/2004 03:37
L PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 11, 2004 14:50
Subject: Re: Date/Time Difference Calculations
> select
sec_to_time(time_to_sec(transfer_end)-time_to_sec(transfer_start));
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
gt;
Sent: Friday, June 11, 2004 14:29
Subject: Re: Date/Time Difference Calculations
Here is an example using sec_to_time. Note that the results are
inconsistent
and sometimes inaccurate. It seems that when the difference is less than
one
minute, the result is correct, when it i
Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
- Original Message -
From: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 11, 2004 14:29
Subject: Re: Date/Time Difference Calculations
>
d, SEC_TO_TIME(end - start) FROM table
>
>
> Eamon Daly
>
>
>
> - Original Message -
> From: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, June 11, 2004 1:57 PM
> Subject: Date/Time D
(NISC)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 11, 2004 1:57 PM
Subject: Date/Time Difference Calculations
> I'm using MySQL version 4.0.18. I have two datetime columns in the same
> table, one that represents a start time and the other that represen
rsion 4.1.x has a lot more date/time functions, but I'm wondering if
something similar can be arrived at under the version that I am using.
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
w
"C.F. Scheidecker Antunes" <[EMAIL PROTECTED]> wrote:
>
> I wonder if is there any way to select from a table all the records
> which has a Date Field that is at least five minutes old?
>
> In other words, I have a table with a date field and I need to select
> all the records that are older th
Hello all,
I wonder if is there any way to select from a table all the records
which has a Date Field that is at least five minutes old?
In other words, I have a table with a date field and I need to select
all the records that are older than five minutes, has their date field
updated
before f
Great, this is more of what I was looking fora way to have the DB auto
populate the date/time in a column, without having to use sql.
Thanks again
cc:
Subject: Re: Newbie - How can I insert
new data with the current
03/15/2003 date/time?
10
ssage-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 15, 2003 20:08
To: [EMAIL PROTECTED]
Subject: Newbie - How can I insert new data with the current date/time?
I have a table called animals (using the example in the MySQL guide). I
have a
datetime column type.
Here is th
At 8:37 -0600 3/15/03, [EMAIL PROTECTED] wrote:
I have a table called animals (using the example in the MySQL guide). I have a
datetime column type.
Here is the table:
Looks like it's called bug_master, not animals. :-)
create table bug_master (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
I have a table called animals (using the example in the MySQL guide). I have a
datetime column type.
Here is the table:
create table bug_master (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
date DATETIME NOT NULL,
PRIMARY
Hi all,
It seems that MS Access can't find out how to "convert" the mysql Time Type
in a table.
Lets say i got 3 colums in a table like this:
create table test (id int(4)auto_increment,dato date,tid time, primary key
(id));
insert into test values ('',curdate(),curtime());
insert into test valu
Chris,
This is how I do it:
SELECT UNIX_TIMESTAMP(time_sign_out) -UNIX_TIMESTAMP(time_sign_in)/3600
AS hours
HTH!
Cory
On Wed, 2002-10-30 at 13:50, Raymer, Chris wrote:
> Having trouble getting the syntax to calculate the time difference given 2 dates
>like so:
>
> A.) 2002-01-02 21:33:0
Having trouble getting the syntax to calculate the time difference given 2 dates like
so:
A.) 2002-01-02 21:33:00
B.) 2002-01-03 00:12:00
In SQL Server could DateDiff. Have tried combinations of TO_DAYS, MINUTE,HOUR etc to
no avail. Please Help.
Chris Raymer
--
t be constants. This means, for example, that you
cannot set the default for a date column to be the value of a function
such as NOW() or CURRENT_DATE."
You have a couple options though, you can use a TIMESTAMP field which will
be set to the current date/time when the data is inserted. But if
Daya,
Thursday, September 26, 2002, 7:53:46 AM, you wrote:
DKD> can anyone tell me how can i set the default datetime as current datetime in
DKD> the mysql. so that every time i insert a record in the table current
DKD> datetime automaticall inserted.
DKD> Thanks in advance.
Take a look at TIMES
Hi,
can anyone tell me how can i set the default datetime as current datetime in
the mysql. so that every time i insert a record in the table current
datetime automaticall inserted.
Thanks in advance.
Regards
Daya Krishan Dubey
Core Solucomm Ltd
423 B, Hamilton court
DLF phase IV
Gurgaon, India
Erick,
Wednesday, September 04, 2002, 10:55:55 AM, you wrote:
EP> i have a date/time column. i insert into it using "now()". works fine.
EP> now i want a query where data/time is either today or yesterday.
EP> how should i do it?
Take a look at DATE and TIME functi
27;s requirement!
Regards,
=dn
> - Original Message -
> From: "DL Neil" <[EMAIL PROTECTED]>
> To: "Erick Papadakis" <[EMAIL PROTECTED]>; "mysql"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, September 04, 2002 3:09 PM
> Subject: Re:
Instead why don't you try
select date_sub(now(), INTERVAL 1 DAY)
Karthik.
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Erick Papadakis" <[EMAIL PROTECTED]>; "mysql"
<[EMAIL PROTECTED]>
Sent: Wednesday, September
Hi Erick,
> i have a date/time column. i insert into it using "now()". works fine.
> now i want a query where data/time is either today or yesterday.
> how should i do it?
Calculate the date required (yesterday and/or today) and then add a time
component of midnight (all z
its select date_sub(now(),INTERVAL 1 DAY)
- Original Message -
From: "Erick Papadakis" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, September 04, 2002 1:25 PM
Subject: problem with date/time column
> hi,
>
> i have a date
hi,
i have a date/time column. i insert into it using "now()". works fine.
now i want a query where data/time is either today or yesterday.
how should i do it?
thanks/erick
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock q
How are people representing subsecond date/time values with MySQL?
In Sybase, the datetime data type supports subsecond values with a
resolution of 1/300th of a second (go figure). PostgreSQL does microseconds
with its time (4 bytes) and timestamp (8 bytes) data types.
More generally, JDBC
--- Jarkko Toivonen <[EMAIL PROTECTED]> wrote:
> I was just wondering that how to add date/time to every report run in
> MySql.
> I've got a database that contains everything about my home-made
> beers. I run
> a select-query sometimes and I want to include the time
* Jarkko Toivonen
> I was just wondering that how to add date/time to every report
> run in MySql.
> I've got a database that contains everything about my home-made
> beers. I run
> a select-query sometimes and I want to include the time when it
> was run in it.
Add &q
I was just wondering that how to add date/time to every report run in MySql.
I've got a database that contains everything about my home-made beers. I run
a select-query sometimes and I want to include the time when it was run in
it.
So, any ideas?
T
with a little date/time problem I'm
>having. I've got a database full of timestamps that I want to group
>together based on their week. I can use the WEEK() function or
>DATE_FORMAT() to convert the timestamp to a week number, but I'd rather
>display the boundary dates f
Well, whatever language you are using to output your data, there should be
some unix tampstamp converting function.
In php it's date().
On Sunday 25 November 2001 04:20 pm, Chris Cooper wrote:
> Hey all,
>
> I'm hoping someone can help me out with a little date/time problem
Hey all,
I'm hoping someone can help me out with a little date/time problem I'm
having. I've got a database full of timestamps that I want to group
together based on their week. I can use the WEEK() function or
DATE_FORMAT() to convert the timestamp to a week number, but I'
Hi there.
I need advice on which is better to store date/time information on a
database and retrieve data between two given dates.
It appears to be pretty simple to use timestamp, which value is always
bigger as time goes on, and I could compare using logical operators in a SQL
query. Is this
i want to extract day and hours/minutes from a date-time field.
in order to to this i use e.g. for the hours:
select
HOUR(hora) as lahora
from mytable
which returns the hour but followed by an "L", same for minutes,
same for the date.
why is this so and how can i avoid it?
we run m
Ch 7 of the manual contains a list of date functions that allows you to do
everything, short of boiling an egg.
- Original Message -
From: "Kevin Xin Lin" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 22:10
Subject
Hi there,
If I need compare 2 fields of DATE and TIME to a field of
TIMESTAMP/DATETIME in my query,
what am I supposed to do? Is there a function to get DATE/TIME part from
a DATETIME field, or combine DATE and TIME to a DATETIME type?
thanks
using the standard functions and
'col_name/100', but that will only be accurate to a second.
Regards
Quentin
-Original Message-
From: Andreas Karl Wittwer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 6 March 2001 2:54 p.m.
To: [EMAIL PROTECTED]
Subject: Date/Time difference
Hell
Hello,
I'm reading this list for some time and checked the FAQ, archive
but i haven't found any hints ...
I have an own written app which is using a 'kind of database' to
calculate the difference between two (or more) events which can
happen between tens or hundreds of seconds.
Now i want to sw
At 10:31 AM -0800 2/5/01, Daniel Kirk wrote:
>Does MySQL have any date/time functions -> can anyone give me a URL where I
>can find some documentation on it. I'm looking for SQLServer equivalents of
>DateAdd(), DateDiff(), Month(), Year() etc
The MySQL Reference Manual is
Does MySQL have any date/time functions -> can anyone give me a URL where I
can find some documentation on it. I'm looking for SQLServer equivalents of
DateAdd(), DateDiff(), Month(), Year() etc
thx dan
-
Before
80 matches
Mail list logo