01-17-2011
Another
very useful site
SS64. I've used it over the years to figure out SQL syntax. The page you will need to look at is
Oracle date formats.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hey all,
When you run the 'ls -la' command it'll show you the time and dates of all files/directories. Now what I am trying to do is create a script that will tell me what files haven't been used in over the past 1 month and what the time and date is that the files that haven't been accessed in... (2 Replies)
Discussion started by: merlin
2 Replies
2. UNIX for Dummies Questions & Answers
Hi All,
I have some files which are creates every day using a script. I want to create a log files which does write "filename,creation day and time"
how can I do this ??
Alice (3 Replies)
Discussion started by: alisevA3
3 Replies
3. UNIX for Dummies Questions & Answers
:confused: I'm not really sure about the default backup date & time in our Unix system and I would like to change it to a convienient time...how do I do that? Please help? (1 Reply)
Discussion started by: EbeyeJJ
1 Replies
4. Shell Programming and Scripting
Hi guys,
I know that this topic has been discuss numerous times, and I have search the net and this forum for it.
However, non able to address the problem I faced so far.
I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their... (5 Replies)
Discussion started by: DrivesMeCrazy
5 Replies
5. UNIX for Dummies Questions & Answers
Hi,
i dont have remote m/c user credential. i only know remote m/c ip address. and i am able to ping that remote m/c.
In windows we use: "net time \\computername" to get the remote m/c time.
so how can i get remote m/c time in unix m/c? (means a unix command)
Thanks for the help.
... (9 Replies)
Discussion started by: partha_ori
9 Replies
6. Shell Programming and Scripting
Hi,
I need to search email files by date & time range in email files.
The timezone is not important.
Can someone plz advise how i can do this ?
For e.g A user can specify only
A single date
A date range
date & time range
Below is part of the email file. (4 Replies)
Discussion started by: coolatt
4 Replies
7. Shell Programming and Scripting
Hello All,
I was having a look on threads on the Forum about time calculation but didn't find exactly this issue.
For instance, if we have these 2 dates, begin & end :
20100430235830
20100501000200
Is there anyway, awk, ksh, perl to calculate the difference in sec and get for... (6 Replies)
Discussion started by: rany1
6 Replies
8. Shell Programming and Scripting
This gives:
grep "qprt -o -dp -N 1 -P" printfile.log.1216 |awk '{print $7, $9}' |grep lpc1z
The output like below:
lpc1z /cerner/d_prod/print/ccltemp4235396d030a.dat.tmp.1216075330]
lpc1z /cerner/d_prod/print/ccltemp4235396d036a.dat.tmp.1216075634]
lpc1z... (2 Replies)
Discussion started by: Daniel Gate
2 Replies
9. UNIX Desktop Questions & Answers
how can i grep a range?
i have a text file with the following text:
result.log.00:2012/01/02 12:00:07.422 LOG STARTED HERE
N6Kashya29MemoryShieldScheduler_AO_IMPLE, pid=8662/8658,
config=(alertThreshold=10,alertLevel=0,killThreshold=7200,coreThreshold=0,full=1),
deltaTime=0,... (1 Reply)
Discussion started by: boaz733
1 Replies
10. Shell Programming and Scripting
Hello All,
This is my first script in PERL. Hence require your help in moving further.
I have a script which should populate the values for Today, Yesterday output.
For which I use timeFrame as a variable to obtain the time in hrs:mm as 10:00.
All I want is, I want my timeFrame to start... (4 Replies)
Discussion started by: sathyaonnuix
4 Replies
LEARN ABOUT DEBIAN
datetime::format::sqlite
DateTime::Format::SQLite(3pm) User Contributed Perl Documentation DateTime::Format::SQLite(3pm)
NAME
DateTime::Format::SQLite - Parse and format SQLite dates and times
SYNOPSIS
use DateTime::Format::SQLite;
my $dt = DateTime::Format::SQLite->parse_datetime( '2003-01-16 23:12:01' );
# 2003-01-16 23:12:01
DateTime::Format::SQLite->format_datetime($dt);
DESCRIPTION
This module understands the formats used by SQLite for its "date", "datetime" and "time" functions. It can be used to parse these formats
in order to create DateTime objects, and it can take a DateTime object and produce a timestring accepted by SQLite.
NOTE: SQLite does not have real date/time types but stores everything as strings. This module deals with the date/time strings as
understood/returned by SQLite's "date", "time", "datetime", "julianday" and "strftime" SQL functions. You will usually want to store your
dates in one of these formats.
METHODS
This class offers the methods listed below. All of the parsing methods set the returned DateTime object's time zone to the UTC zone
because SQLite does always uses UTC for date calculations. This means your dates may seem to be one day off if you convert them to local
time.
o parse_datetime($string)
Given a $string representing a date, this method will return a new "DateTime" object.
The $string may be in any of the formats understood by SQLite's "date", "time", "datetime", "julianday" and "strftime" SQL functions or
it may be in the format returned by these functions (except "strftime", of course).
The time zone for this object will always be in UTC because SQLite assumes UTC for all date calculations.
If $string contains no date, the parser assumes 2000-01-01 (just like SQLite).
If given an improperly formatted string, this method may die.
o parse_date($string)
o parse_time($string)
o parse_julianday($string)
These are aliases for "parse_datetime", for symmetry with "format_*" functions.
o format_date($datetime)
Given a "DateTime" object, this methods returnes a string in the format YYYY-MM-DD, i.e. in the same format SQLite's "date" function
uses.
o format_time($datetime)
Given a "DateTime" object, this methods returnes a string in the format HH:MM:SS, i.e. in the same format SQLite's "time" function
uses.
o format_datetime($datetime)
Given a "DateTime" object, this methods returnes a string in the format YYYY-MM-DD HH:MM:SS, i.e. in the same format SQLite's
"datetime" function uses.
o format_julianday($datetime)
Given a "DateTime" object, this methods returnes a string in the format DDDDDDDDDD, i.e. in the same format SQLite's "julianday"
function uses.
AUTHOR
Claus Faerber <CFAERBER@cpan.org>
based on "DateTime::Format::MySQL" by David Rolsky.
Copyright X 2008 Claus Faerber.
Copyright X 2003 David Rolsky.
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
http://datetime.perl.org/
http://www.sqlite.org/lang_datefunc.html
perl v5.10.1 2009-12-10 DateTime::Format::SQLite(3pm)