04-18-2012
Timestamp problem
I have a date/timestamp problem I can't figure out. I have an Oracle table with a column DEL_TIMESTAMP defined as a NUMBER. The min and max values in the column are:
6.3417E+17
6.3470E+17
the bottom value is: 634700000000000000
Is this the time since the epoch? How does this represent date/time?
any helped is appreicated.
thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
from a shell script I am copying 2 different set of files in 2 different directories and then it ftp the same set files to another server 2 different
directories.
the dest directories where it is copying the files own by a different user
and required permission is there... (0 Replies)
Discussion started by: sankar
0 Replies
2. Programming
Hi all.
I have the following code:
#include<stdio.h>
#include<time.h>
int main()
{
struct tm tm;
time_t time = 1262322000; /*Jan, 01, 2010*/
char temp;
int i = 0;
while(i < 4)
{
memset(temp, 0, 128);
localtime_r(&time,... (2 Replies)
Discussion started by: adm1n
2 Replies
3. Shell Programming and Scripting
Hi,
I've a file in the following format
1999-APR-8 17:31:06 1500 3 45
1999-APR-8 17:31:15 1500 3 45
1999-APR-8 17:31:25 1500 3 45
1999-APR-8 17:31:30 1500 3 45
1999-APR-8 17:31:55 1500 3 45
1999-APR-8 17:32:06 1500 3 ... (1 Reply)
Discussion started by: vaibhavkorde
1 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I am trying to insert a timestamp after all the file names in a folder,after the timestamp is created in the filename the file size is becoming zero bytes.
please tell me where I am doing it wrong.
I have declared the variable in starting of my script.
timestamp=`date... (1 Reply)
Discussion started by: shruthidwh
1 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I am new to unix programming. I am trying for a requirement and the requirement goes like this.....
I have a test folder. Which tracks log files. After certain time, the log file is getting overwritten by another file (randomly as the time interval is not periodic). I need to preserve... (2 Replies)
Discussion started by: mailsara
2 Replies
6. Shell Programming and Scripting
I need to be able to identify files with file timestamps greater than a given timestamp.
I am using the following solution, although it appears to compare files at the "seconds" granularity and I need it at the milliseconds. When I tested my solution, it missed files that had timestamps... (3 Replies)
Discussion started by: nkm0brm
3 Replies
7. Shell Programming and Scripting
Hi Friends,
I have the following logfile. Currently time in india is 07/31/2014 12:33:34 and i have the following content in logfile. I want to display only those entries which contain string 'Exception' within last 3 hours. In this case, it would be the last line only
I can get the... (12 Replies)
Discussion started by: srkmish
12 Replies
8. Shell Programming and Scripting
Hi Team,
i need some help on finding one hour back time.
if current time is 5:18:22 means i have to find 4:18:22
i am having scenario to pull record which as got inserted morethan one hour back
in table time stamp is 2014-12-22 05:15:13.788875
can any one help me on this
Thanks
Vij (5 Replies)
Discussion started by: bhaskar v
5 Replies
9. Shell Programming and Scripting
Hello ,
I am working on AIX. I have to convert Unix timestamp to normal timestamp. Below is the file. The Unix timestamp will always be preceded by
EFFECTIVE_TIME as first field as shown and there could be multiple EFFECTIVE_TIME in the file : 3.txt
Contents of... (6 Replies)
Discussion started by: rahul2662
6 Replies
10. Shell Programming and Scripting
So basically I have a log file and each line in this log file starts with a timestamp:
MON DD HH:MM:SS
SEP 15 07:30:01
I need to grep all the lines between last hour timestamp and current timestamp. Then these lines will be moved to a tmp file from which I will grep for particular strings. ... (1 Reply)
Discussion started by: nms
1 Replies
LEARN ABOUT MOJAVE
dbix::class::inflatecolumn5.18
DBIx::Class::InflateColumn(3) User Contributed Perl Documentation DBIx::Class::InflateColumn(3)
NAME
DBIx::Class::InflateColumn - Automatically create references from column data
SYNOPSIS
# In your table classes
__PACKAGE__->inflate_column('column_name', {
inflate => sub {
my ($raw_value_from_db, $result_object) = @_;
...
},
deflate => sub {
my ($inflated_value_from_user, $result_object) = @_;
...
},
});
DESCRIPTION
This component translates column data into references, i.e. "inflating" the column data. It also "deflates" references into an appropriate
format for the database.
It can be used, for example, to automatically convert to and from DateTime objects for your date and time fields. There's a convenience
component to actually do that though, try DBIx::Class::InflateColumn::DateTime.
It will handle all types of references except scalar references. It will not handle scalar values, these are ignored and thus passed
through to SQL::Abstract. This is to allow setting raw values to "just work". Scalar references are passed through to the database to deal
with, to allow such settings as " 'year + 1'" and " 'DEFAULT' " to work.
If you want to filter plain scalar values and replace them with something else, see DBIx::Class::FilterColumn.
METHODS
inflate_column
Instruct DBIx::Class to inflate the given column.
In addition to the column name, you must provide "inflate" and "deflate" methods. The "inflate" method is called when you access the field,
while the "deflate" method is called when the field needs to used by the database.
For example, if you have a table "events" with a timestamp field named "insert_time", you could inflate the column in the corresponding
table class using something like:
__PACKAGE__->inflate_column('insert_time', {
inflate => sub {
my ($insert_time_raw_value, $event_result_object) = @_;
DateTime->from_epoch( epoch => $insert_time_raw_value );
},
deflate => sub {
my ($insert_time_dt_object, $event_result_object) = @_;
$insert_time_dt_object->epoch;
},
});
The coderefs you set for inflate and deflate are called with two parameters, the first is the value of the column to be inflated/deflated,
the second is the result object itself.
In this example, calls to an event's "insert_time" accessor return a DateTime object. This DateTime object is later "deflated" back to the
integer epoch representation when used in the database layer. For a much more thorough handling of the above example, please see
DBIx::Class::DateTime::Epoch
get_inflated_column
my $val = $obj->get_inflated_column($col);
Fetch a column value in its inflated state. This is directly analogous to "get_column" in DBIx::Class::Row in that it only fetches a
column already retrieved from the database, and then inflates it. Throws an exception if the column requested is not an inflated column.
set_inflated_column
my $copy = $obj->set_inflated_column($col => $val);
Sets a column value from an inflated value. This is directly analogous to "set_column" in DBIx::Class::Row.
store_inflated_column
my $copy = $obj->store_inflated_column($col => $val);
Sets a column value from an inflated value without marking the column as dirty. This is directly analogous to "store_column" in
DBIx::Class::Row.
SEE ALSO
DBIx::Class::Core - This component is loaded as part of the "core" DBIx::Class components; generally there is no need to load it directly
AUTHOR
Matt S. Trout <mst@shadowcatsystems.co.uk>
CONTRIBUTORS
Daniel Westermann-Clark <danieltwc@cpan.org> (documentation)
Jess Robinson <cpan@desert-island.demon.co.uk>
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.18.2 2013-12-16 DBIx::Class::InflateColumn(3)