Hello all,
Had a normal MySQL shutdown, reboot and then this happens:
161010 10:58:30 [Note] Plugin 'FEDERATED' is disabled.
161010 10:58:31 InnoDB: The InnoDB memory heap is disabled
161010 10:58:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions
161010 10:58:31 InnoDB: Compressed
I wrote a Java program to connect with MySQL server. As long as it was
loose classes in a directory, it worked. As soon as I made it into a JAR
file, I had trouble. If I used flag "classpath" to refer to the
connector, the connector was not found: with flag "-XshowSettings" I saw
that the conne
> if you define a column with any name and a type of
>
> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Thanks Lucio,
This is much better advice than the NOW() built-in function I would
have suggested.
Kind Regards,
-Bob
--
MySQL General Mailing List
For list archives
On Tue, 2 Jun 2015, Selvam Gce wrote:
Is there any way to get row inserted time or modified time in my mysql
table???
if you define a column with any name and a type of
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
this will automatically timestamp each record
Hi
you should do that in your App with Triggers and an audit table.
You will see timestamps also in binary log (in case you enabled that)
On Tue, Jun 2, 2015 at 11:28 AM, Selvam Gce wrote:
> Is there any way to get row inserted time or modified time in my mysql
> table? Thanks &am
Is there any way to get row inserted time or modified time in my mysql table?
Thanks & Regards,
Selvam | Linkedin
On 2015/04/09 13:42, Michael Dykman wrote:
A trigger is far simpler than remodelling your data and adding extra
queries. They are nothing to be afraid of.
Not afraid of, but to be careful when writing. I have had trouble with
my triggers, because I left this&that out. As for timestamping, MyS
in any of
>>> four different columns, but I don¹t care about changes in other
>>> columns or
>>> added columns.
>>>
>>> Is there a command that says ³update the time stamp if and only if there
>>> is a change in columns a, b,c, or
ble where I care about changes in any of
four different columns, but I don¹t care about changes in other
columns or
added columns.
Is there a command that says ³update the time stamp if and only if there
is a change in columns a, b,c, or d"
--
MySQL General Mailing List
For lis
W dniu 08.04.2015 o 17:42, Andrew Wallace pisze:
I think you'd have to do that with a trigger.
+1 for using triggers.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
anges in any of
four different columns, but I don¹t care about changes in other columns or
added columns.
Is there a command that says ³update the time stamp if and only if there
is a change in columns a, b,c, or d"
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
columns.
Is there a command that says ³update the time stamp if and only if there
is a change in columns a, b,c, or d"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
sh) may make a difference. This
will disable fetching schema information on all possible table
and column names for tab completion which can take quite some
time depending on the shema size of the database you're
connecting to ...
--
Hartmut Holzgraefe, Principal Support Engine
Can someone help explain something to me? When I use "mysql" to connect
to my server, it can take upwards of 15 seconds. When I use any of the
Ruby scripts I've written, it's so fast it's not even obvious it's
querying a remote host. Any idea what might cause this disparity? (My
initial sus
date digits, "140930" at
the beginning looks like September 30, 2014.
If that's the case, you need to write something that will tear it apart.
<<<<<<<<
MySQL s interpretation of timestamps is already such that not much such code is
needed: see "Overview of
- 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 come
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.
Maybe it's because I'm accessing it through a C Panel SSH Shell that it
acts differently than you expected. It doesn't matter anyway… I was able
to exit the shell and regain control of my shell. I'm giving up on the
upgrade approach for now, so let's consider this conversation concluded.
On We
Am 21.08.2014 um 01:05 schrieb Augori:
> when I use the bg command, it says
>
> 1 job already in background
>
> and continues to run in the foreground.
*bullshit* if it is running in foreground you can't enter
anything because your terminal would be blocked, the bg
command only works if you s
Hi All,
when I use the bg command, it says
1 job already in background
and continues to run in the foreground.
On Wed, Aug 20, 2014 at 11:04 AM, Reindl Harald
wrote:
>
>
> Am 20.08.2014 um 16:39 schrieb Augori:
> > However, it's been 12 hours now and the thing is still restarting in safe
> >
Am 20.08.2014 um 18:55 schrieb Augori:
> Thanks! But if it's running in the background, how will I know when it has
> completed?
completed what?!
http://www.catb.org/esr/faqs/smart-questions.html#beprecise
what did you not understand in the paragraph below?
>> mysqld_safe has *nothing* to do
Thanks! But if it's running in the background, how will I know when it has
completed?
On Wed, Aug 20, 2014 at 11:04 AM, Reindl Harald
wrote:
>
>
> Am 20.08.2014 um 16:39 schrieb Augori:
> > However, it's been 12 hours now and the thing is still restarting in safe
> > mode and I can't tell if i
Am 20.08.2014 um 16:39 schrieb Augori:
> However, it's been 12 hours now and the thing is still restarting in safe
> mode and I can't tell if it's making progress. The command I typed was
>
> /usr/bin/mysqld_safe --skip-grant-tables&
>
> I think I forgot to include the ampersand (&) at the end
Hi all,
mysql db has been starting in safe mode for 12 hours. I don't know if I
should stop it or if I do, what will happen. I'm hoping one of you can
help.
Here's how I got into this mess:
After a operating system change (CentOS 5 to CentOS 6), my Python script
could no longer connect with mys
Hi Satendra,
On 7/14/2014 5:48 AM, Satendra wrote:
Hi there, I'm struggling to find the total time taken by a database query
on the disk? As I understand when a database query start execution it takes
some time inside the database engine & some time to seek the result from
disk (if th
Hi Satendra,
On Jul 14, 2014, at 3:48 AM, Satendra wrote:
> Hi there, I'm struggling to find the total time taken by a database query
> on the disk? As I understand when a database query start execution it takes
> some time inside the database engine & some time to seek the
ngle:
http://www.markleith.co.uk/2011/05/23/monitoring-mysql-io-latency-with-performance_schema/
keith
On Mon, Jul 14, 2014 at 5:59 AM, Reindl Harald
wrote:
>
>
> Am 14.07.2014 12:48, schrieb Satendra:
> > Hi there, I'm struggling to find the total time taken by a database query
> >
Am 14.07.2014 12:48, schrieb Satendra:
> Hi there, I'm struggling to find the total time taken by a database query
> on the disk? As I understand when a database query start execution it takes
> some time inside the database engine & some time to seek the result from
> di
Hi there, I'm struggling to find the total time taken by a database query
on the disk? As I understand when a database query start execution it takes
some time inside the database engine & some time to seek the result from
disk (if that is not in cache/buffer)
Can anybody from the gro
2013/08/22 14:22 -0400, Nick Cameo
SimpleDateFormat sdf = new SimpleDateFormat("-MM-dd'T'HH:mm:ss", new
Locale("en", "US"));
Well, you have your answer (FROM_UNIXTIME( /1000)), but that stupid ISO
format with 'T' in the middle does not work, because to MySQL letters are n
Sorry, as was mentioned earlier:
select FROM_UNIXTIME(1377196112065/1000);
+---+
| FROM_UNIXTIME(1377196112065/1000) |
+---+
| 2013-08-22 18:28:32 |
+---+
Have a good day everyone :)
Ni
t;
> The same effect may be gotten with any timestamp-formatting function that
> yields a string in the form '2013/08/21 18:03:00' (it is all one whether
> the separator is hyphen, slant, colon, ...).
>
>
> --
> MySQL General Mailing List
> For list archives: http
2013/08/21 18:03 -0400, Nick Khamis
We have the following mysql timetampe field
startdate | timestamp | NO | | -00-00 00:00:00
When trying to insert a long value in there:
Calendar c = Calendar.getInstance(TimeZone.getTimeZone("UTC"));
c.getTimeInMillis();
We are presented w
Nick,
You should have answered your own question in the text.
The MySql TIMESTAMP type is, as all other timestamps in the *nix
world, a count of seconds since epoch time. The Java function you are
using yields MILLI-seconds. Divide it by 1000 and you should be good
to go.
On Wed, Aug 21
Hello Everyone,
We have the following mysql timetampe field
startdate | timestamp | NO | | -00-00 00:00:00
When trying to insert a long value in there:
Calendar c = Calendar.getInstance(TimeZone.getTimeZone("UTC"));
c.getTimeInMillis();
We are presented with the following error:
com
Hello Joe
On 4/5/2013 10:25 AM, Joe Kosinski wrote:
I have installed the community edition version 5.6 to my MacBook running
OSX 10.8.3. I am trying to set up MythTV backend which requires the
time zone tables to be loaded for the database I will be using.
I have not been able to load the
Hi Joseph,
We request that except for sensitive information that you keep all
responses on the list. This way the entire community can kick in for
assistance.
On 4/5/2013 12:25 PM, Joseph Kosinski wrote:
Thanks for your response. This has been troubling me for days! I am
not too familiar wi
Hi Incarus,
You don't need a loop just a correlated subquery on the update:
UPDATE TB1 SET Ivet=PREG_REPLACE('/TeXT/', '', Ivet);
Example:
mysql> CREATE TABLE blah(value INTEGER, square INTEGER);
Query OK, 0 rows affected (0.17 sec)
mysql> INSERT INTO blah(value) VALUES (1),(2),(3),(4),(5);
Q
I have a two line query that is only able to handle 1 row per
execution. Could any of you give me some insight on how I could loop this
per every single row in the table? The query in question is:
SELECT PREG_REPLACE('/TeXT/', '' , Ivet) FROM `DB1`.`TB1` INTO @VAR12;
UPDATE `TB1` SET Ivet = @VAR12
Look at Nodejs, asynchronous server-side programming environment.
That combined with some basic MySql triggers could do it for you.
On 08/13/2012 04:07 PM, Rafael Valenzuela wrote:
Hi all,
i've a question about the mysql configuration, in my project, we need use
data in real time (rea
Hi all,
i've a question about the mysql configuration, in my project, we need use
data in real time (read and insert) . But i don't idea about this matter.
Any advice or information?
i'm so sorry the hassle.
--
Mit forever
My Blog <http://www.redcloverbi.wordpress.com>
2012/07/24 13:07 -0700, Hassan Schroeder
On Tue, Jul 24, 2012 at 10:36 AM, Roberta Jaskólski wrote:
> version(): 5.5.8-log
> @@sql_mode:
> REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_DATE,ALLOW_INVALID_DATES,NO_AUTO_CR
2012/07/24 08:46 -0700, Hassan Schroeder
On Mon, Jul 23, 2012 at 5:58 AM, wrote:
> I thought I would try YEAR to record it--but, in spite of
> http://dev.mysql.com/doc/refman/5.5/en/year.html , simply assigning NOW() to
> such a type does not work.
Not sure I understand the issue:
2012/07/23 11:54 -0700, Rick James
mysql> SELECT YEAR(NOW());
+-+
| YEAR(NOW()) |
+-+
|2012 |
+-+
mysql> SELECT CONCAT('2012', '-01-01');
+--+
| CONCAT('2012', '-01-01') |
+--+
| 2012-01-01
And don't kill replication when you see a big time in processlist.
> therefore the time get accumulated
?? Each query stands alone in timing. The "idle" time is caught by
wait_timeout, which was already mentioned. You can distinguish the cases by
whether processlis
1-01') - INTERVAL 1 day |
+---+
| 2011-12-31|
+---+
> -Original Message-
> From: h...@tbbs.net [mailto:h...@tbbs.net]
> Sent: Monday, July 23, 2012 5:59 AM
> To: mysql@lists.mysql.com
> Subject: YEAR and time types
&g
t;>
>> The programms watch certain states in the database,
>> the connect automatic at db startup, disconnecting
>> is an error case.
>
> so why do you want to restrict connect time
> if this is a error-case for you?
>
no, this is a misunderstanding,
i want to
not very clear. You use connection pooling, right.
If the same session/thread is held for long time, it means the thread is
not getting closed even after doing its job, and adding to execution time.
On Mon, Jul 23, 2012 at 9:05 PM, walter harms wrote:
>
>
> Am 23.07.2012 16:58, schri
ic at db startup, disconnecting
> is an error case.
so why do you want to restrict connect time
if this is a error-case for you?
signature.asc
Description: OpenPGP digital signature
2 at 8:17 PM, walter harms wrote:
>
>>
>>
>> Am 23.07.2012 16:37, schrieb Ananda Kumar:
>>> why dont u setup a staging env, which is very much similar to your
>>> production and tune all long running sql
>>>
>>
>> They are tuned and they ar
all long running sql
> >
>
> They are tuned and they are fast :) but the never logout and therefore
> the time get accumulated.
>
> re,
> wh
>
>
> > On Mon, Jul 23, 2012 at 8:02 PM, walter harms wrote:
> >
> >>
> >>
> >> Am 23.0
Am 23.07.2012 16:37, schrieb Ananda Kumar:
> why dont u setup a staging env, which is very much similar to your
> production and tune all long running sql
>
They are tuned and they are fast :) but the never logout and therefore
the time get accumulated.
re,
wh
> On Mon, Jul 2
#x27;s which
> > are taking more time to execute
> >
>
> Yes but you will see the results only when the query is finished.
> my first idea was to use something like this:
> select * from information_schema.processlist where state like 'executing'
> and time >
Am 23.07.2012 16:10, schrieb Ananda Kumar:
> you can check the slow query log, this will give you all the sql's which
> are taking more time to execute
>
Yes but you will see the results only when the query is finished.
my first idea was to use something like this:
you can check the slow query log, this will give you all the sql's which
are taking more time to execute
On Mon, Jul 23, 2012 at 7:38 PM, walter harms wrote:
>
>
> Am 23.07.2012 15:47, schrieb Ananda Kumar:
> > you can set this is in application server.
> > You can
gt;
> On Mon, Jul 23, 2012 at 6:18 PM, walter harms wrote:
>
>> Hi list,
>> is there a switch where i can restrict the connect/execution time for a
>> query ?
>>
>> re,
>> wh
>>
>> --
>> MySQL General Mailing List
>> For list
cution time for a
> query ?
>
> re,
> wh
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
A director s term ends in a given year, but at no given time of year; depends
on the yearly meeting.
I thought I would try YEAR to record it--but, in spite of
http://dev.mysql.com/doc/refman/5.5/en/year.html , simply assigning NOW() to
such a type does not work. There is also no implicit
Hi list,
is there a switch where i can restrict the connect/execution time for a query ?
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
ginal Message-
> From: Cabbar Duzayak [mailto:cab...@gmail.com]
> Sent: Friday, July 06, 2012 8:46 AM
> To: mysql@lists.mysql.com
> Subject: Subquery taking too much time on 5.5.18?
>
> Hi Everyone,
>
> I have been trying to understand why subqueries are taking tooo mu
To: mysql@lists.mysql.com
> Subject: Re: Subquery taking too much time on 5.5.18?
>
>
>
> Am 06.07.2012 17:46, schrieb Cabbar Duzayak:
> > Hi Everyone,
> >
> > I have been trying to understand why subqueries are taking tooo much
> > time on my installation of MySQL
lists.mysql.com
> Subject: Re: Fwd: Query take too long time - please help!
>
> On 10.07.2012 13:16, Darek Maciera wrote:
> > 2012/7/10 Ananda Kumar :
> >> can u show the explain plan for your query
> >>
> >
> > Thanks, for reply!
> >
> >
On 10.07.2012 13:16, Darek Maciera wrote:
2012/7/10 Ananda Kumar :
can u show the explain plan for your query
Thanks, for reply!
Sure:
mysql> EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
That's definitely not the query you showed the first time
you are using a function-LOWER, which will not make use of the unique key
index on ksd.
Mysql does not support function based index, hence your query is doing a
FULL TABLE scan and taking more time.
On Tue, Jul 10, 2012 at 4:46 PM, Darek Maciera wrote:
> 2012/7/10 Ananda Kumar :
> > c
2012/7/10 Ananda Kumar :
> can u show the explain plan for your query
>
Thanks, for reply!
Sure:
mysql> EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
++-+-+--+---+--+-+--++-+
| id | se
ips |1 | ips | A |
> 8 | NULL | NULL | | BTREE | |
> | books | 1 | idx_ips2 |1 | ips2 | A |
> 8 | NULL | NULL | | BTREE | |
>
> Every books have unique: 'ksd'. There are about 370.000 record
ds in this table.
But this SELECT take too long time:
mysql> SELECT * FROM books WHERE ksd ='A309CC47B7';
1 row in set (2.59 sec)
Table is in InnoDB engine. I added to my.cnf: innodb_buffer_pool_size = 512MB
Any suggestions? Help, please..
--
MySQL General Mailing List
For list arc
mysql> SELECT @@optimizer_switch;
++
| @@optimizer_switch
|
+
On 2012-07-07 9:52 AM, Cabbar Duzayak wrote:
Hmm,
Looking at the link http://www.artfulsoftware.com/infotree/queries.php
and explanations here, EXISTS() should have performed better, but does
not seem to??? I stopped it after about 5 minutes.
I tried both:
SELECT * FROM A WHERE EXISTS (SELE
Hmm,
Looking at the link http://www.artfulsoftware.com/infotree/queries.php
and explanations here, EXISTS() should have performed better, but does
not seem to??? I stopped it after about 5 minutes.
I tried both:
SELECT * FROM A WHERE EXISTS (SELECT * FROM B WHERE A.id=B.A_ID and
B.name like 'X
> See "The unbearable slowness of IN()" at
> http://www.artfulsoftware.com/infotree/queries.php
Do you read your own links? Excerpt:
> In 5.0, EXISTS() is much faster than IN(), but slower than JOIN. In 5.5,
EXISTS() performs about as well as JOIN.
So judging by the subject line...
--
My
oftware.com/infotree/queries.php
SELECT a.*
FROM a
JOIN b USING(a_id)
WHERE B.name LIKE 'X%';
PB
-
Does it help?
David.
-Original Message-
From: Cabbar Duzayak [mailto:cab...@gmail.com]
Sent: Friday, July 06, 2012 11:46 AM
To: mysql@lists.mysql.com
Subject: Subquery takin
2 11:46 AM
To: mysql@lists.mysql.com
Subject: Subquery taking too much time on 5.5.18?
Hi Everyone,
I have been trying to understand why subqueries are taking tooo much
time on my installation of MySQL 5.5.18 on Ubuntu 11.10 release.
In a nutshell, I have 2 tables: A and B. And, I do something
forcing MySQL to run
> from the inside out. I don't have a running instance nearby to test on, but I
> hope it helps.
>
>
>
>
>
>
> -Original Message-
> From: Reindl Harald [mailto:h.rei...@thelounge.net]
> Sent: Friday, July 06, 2012 11:58 AM
&g
ping the subquery within another subquery, forcing MySQL to run
from the inside out. I don't have a running instance nearby to test on, but I
hope it helps.
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Friday, July 06, 2012 11:58 AM
To: mysql@lists.
Am 06.07.2012 17:46, schrieb Cabbar Duzayak:
> Hi Everyone,
>
> I have been trying to understand why subqueries are taking tooo much
> time on my installation of MySQL 5.5.18 on Ubuntu 11.10 release.
>
> In a nutshell, I have 2 tables: A and B. And, I do something like this:
Hi Everyone,
I have been trying to understand why subqueries are taking tooo much
time on my installation of MySQL 5.5.18 on Ubuntu 11.10 release.
In a nutshell, I have 2 tables: A and B. And, I do something like this:
SELECT * FROM A WHERE A.id IN (SELECT A_ID FROM B WHERE B.name like &#
On 1/27/2012 12:09 PM, John Heim wrote:
I'm trying to create a function that formats a time in a standard way
('%H:%i'). But all I can seem to get back is null.
DROP TABLE IF EXISTS bogus_table;
CREATE TABLE IF NOT EXISTS bogus_table (
btime TIME
);
INSERT INTO bogus_table VA
I'm trying to create a function that formats a time in a standard way
('%H:%i'). But all I can seem to get back is null.
DROP TABLE IF EXISTS bogus_table;
CREATE TABLE IF NOT EXISTS bogus_table (
btime TIME
);
INSERT INTO bogus_table VALUES ('12:34:56');
DROP
>
> leave it stored as a timestamp type or datetime type, and when you need to
> display it otherwise.. then covert with date()
oops, Paul's post reminded me I was suggesting a PHP function here ^^^ ... and
this is the MySQL list.
> -G
--
MySQL General Mailing List
For list archives: http:/
On Jan 8, 2012, at 2:21 PM, Donovan Brooke wrote:
> Hello, I'm doing an insert into with date and time type fields.
>
> I was reading:
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-literals.html
>
> My question is: is the format always 'year month day&#x
> What's your problem/reason with how it is?
I assume Andy means:
leave it stored as a timestamp type or datetime type, and when you need to
display it otherwise.. then covert with date()
-G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
Peter Brawley wrote:
On 1/8/2012 2:21 PM, Donovan Brooke wrote:
Hello, I'm doing an insert into with date and time type fields.
I was reading:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-literals.html
My question is: is the format always 'year month day'?.. or can w
On 1/8/2012 2:21 PM, Donovan Brooke wrote:
Hello, I'm doing an insert into with date and time type fields.
I was reading:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-literals.html
My question is: is the format always 'year month day'?.. or can we
save dates in
What's your problem/reason with how it is?
Andy
On Sun, Jan 8, 2012 at 8:21 PM, Donovan Brooke wrote:
> Hello, I'm doing an insert into with date and time type fields.
>
> I was reading:
> http://dev.mysql.com/doc/**refman/5.1/en/date-and-time-**literals.html<http:/
Hello, I'm doing an insert into with date and time type fields.
I was reading:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-literals.html
My question is: is the format always 'year month day'?.. or can we save
dates in 'month day year' as well?
Thanks,
Donova
wrote:
> - Original Message -
> > From: "Peng Yu"
> >
> > Suppose I have two servers (one on mac and one on ubuntu), at any
> > time I only change one server but not both servers. After I have done
> >
> > I think that probably it is OK to synchr
- Original Message -
> From: "Peng Yu"
>
> Suppose I have two servers (one on mac and one on ubuntu), at any
> time I only change one server but not both servers. After I have done
>
> I think that probably it is OK to synchronize these two servers at
>
servers (one on mac and one on ubuntu), at any time
I only change one server but not both servers. After I have done
changes on A, I want to propagate the changes to B. After I have done
changes on B, I want to propagate the changes to A.
I think that probably it is OK to synchronize these two servers at
Thanks, Hank!
I figured it was something like that, but couldn't see any clear documentation
on the Oracle reference page on date/time functions.
On Sep 30, 2011, at 8:22 PM, Hank wrote:
> n Fri, Sep 30, 2011 at 11:08 PM, Jan Steinman wrote:
>> Okay, I've reviewed the onlin
>>>> 2011/09/30 20:08 -0700, Jan Steinman >>>>
Okay, I've reviewed the online man page for date and time functions, and I've
played with several likely candidates, and I am still having trouble
subtracting two arbitrary Datetimes to get something that is useful
n Fri, Sep 30, 2011 at 11:08 PM, Jan Steinman wrote:
> Okay, I've reviewed the online man page for date and time functions, and I've
> played with several likely candidates, and I am still having trouble
> subtracting two arbitrary Datetimes to get something that
Okay, I've reviewed the online man page for date and time functions, and I've
played with several likely candidates, and I am still having trouble
subtracting two arbitrary Datetimes to get something that is useful. A simple
subtraction yields the least useful thing possible: a
he end of the query running it displays the time how much it
> > took.
> >
> > Or else enable the profiling and run the query to check the exact time it
> > took for execution at all levels.
> >
> > On Mon, Aug 1, 2011 at 12:11 PM, Adarsh Sharma > >wrote:
> >
at the end of the query running it displays the time how much it
> took.
>
> Or else enable the profiling and run the query to check the exact time it
> took for execution at all levels.
>
> On Mon, Aug 1, 2011 at 12:11 PM, Adarsh Sharma >wrote:
>
> > Dear all,
> &g
Usually, at the end of the query running it displays the time how much it
took.
Or else enable the profiling and run the query to check the exact time it
took for execution at all levels.
On Mon, Aug 1, 2011 at 12:11 PM, Adarsh Sharma wrote:
> Dear all,
>
> I want to know how much ti
1 - 100 of 1449 matches
Mail list logo
