Dear community,
I have to make a "simple" query on ORACLE 11g DB who will output ONLY numbers in field1 who exceeded a specific threshold.
In other words, assuming I have the following data in database.
FIELD1 FIELD2 FIELD3
========= ============== ... (3 Replies)
On psql
select titolo,lingua from titolo where titolo ~* 'brivid';
titolo | lingua
------- + ------
Brivido | 1
On Sqlplus/gqsql
SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%';
TITOLO... (6 Replies)
Dear All,
I have a requirement where there are applicaions installed in Unix machine that has to update a set of Oracle data base installed in Windows machine, the question I have here is, which protocol alows Unix application to interact with Database in Windows env. and do we require some... (2 Replies)
Hello All,
I'm a complete Unix newbie, and I have been asked to provide a solution for the following opportunity:
Currently there is an Oracle database residing on a Unix box that I need to connect to on a regular basis from another Unix box. Upon connecting I need to hit multiple tables and... (6 Replies)
Secure packet filtering on high-bandwidths fw/rtr for large business tasks. Has anyone tried this concept on openbsd?
The article is posted at www.sysadminmag.com on page 27. January 2002 issue.
I believe Mike has hit upon something that can be applied in the field today and prevent fw... (0 Replies)
DateTime::Format::MySQL(3pm) User Contributed Perl Documentation DateTime::Format::MySQL(3pm)NAME
DateTime::Format::MySQL - Parse and format MySQL dates and times
SYNOPSIS
use DateTime::Format::MySQL;
my $dt = DateTime::Format::MySQL->parse_datetime( '2003-01-16 23:12:01' );
# 2003-01-16 23:12:01
DateTime::Format::MySQL->format_datetime($dt);
DESCRIPTION
This module understands the formats used by MySQL for its DATE, DATETIME, TIME, and TIMESTAMP data types. It can be used to parse these
formats in order to create DateTime objects, and it can take a DateTime object and produce a string representing it in the MySQL format.
METHODS
This class offers the following methods. All of the parsing methods set the returned DateTime object's time zone to the floating time
zone, because MySQL does not provide time zone information.
* parse_datetime($string)
* parse_date($string)
* parse_timestamp($string)
Given a value of the appropriate type, this method will return a new "DateTime" object. The time zone for this object will always be
the floating time zone, because by MySQL stores the local datetime, not UTC.
If given an improperly formatted string, this method may die.
* format_date($datetime)
* format_time($datetime)
* format_datetime($datetime)
Given a "DateTime" object, this methods returns an appropriately formatted string.
SUPPORT
Support for this module is provided via the datetime@perl.org email list. See http://lists.perl.org/ for more details.
AUTHOR
Dave Rolsky <autarch@urth.org>
COPYRIGHT
Copyright (c) 2003 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
The full text of the license can be found in the LICENSE file included with this module.
SEE ALSO
datetime@perl.org mailing list
http://datetime.perl.org/
perl v5.8.8 2006-10-23 DateTime::Format::MySQL(3pm)