04-15-2011
timestamp field was padded with blanks warning
There are two columns on the data base table, create and update timestamps of datatype timestamp.
I dont have these fields on the csv file. So I am doing the below.
awk -F , -v d="$(date "+ %Y-%m-%d-%H.%M.%S")" '{ OFS=FS; print $1, $2, $3, $4, d, $5, $6, d }' temp.csv > temp1.csv
and then I insert the data to the table. Its inserting the data fine to the table.
But it throws the below warning for each row its inserting when I run the script.
How do I get rid of this warning ?
SQL3129W The date, time, or timestamp field containing "2011-04-14-16.22.39"
in row "1" and column "8" was padded with blanks.
Thank you in advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
While concatenating 2 values, one which expanded to fixed width & other not, I am not getting value expanded as fixed width.
Following is script for the same :
#!/bin/sh
var1="abc"
var2="def"
var1Fxd=`echo $var1 | awk '{printf("%-6s",$0)}'`
echo $var1Fxd""$var2
But, if I try -
echo... (2 Replies)
Discussion started by: videsh77
2 Replies
2. Shell Programming and Scripting
Greetings,
I am new to scripting, but find if I can see the code working for a given problem, then I can eventually figure it out. (9 Replies)
Discussion started by: rocinante
9 Replies
3. Filesystems, Disks and Memory
how can search for files that are non-zero length but are empty? (1 Reply)
Discussion started by: polive96
1 Replies
4. UNIX for Dummies Questions & Answers
I have a filename 'INITIATE_FINAL_ALL_000080889.dat', and I want to capture just the number '80889' from it.
Here is what I have so far:
%> echo INITIATE_FINAL_ALL_000080889.dat | sed "s/*//g"
000080889
Now, I just need to trim off the padded zeroes.
Thanks,
- CB (3 Replies)
Discussion started by: ChicagoBlues
3 Replies
5. Shell Programming and Scripting
Hi all. Im trying to use a sequence in a while loop like this below. I need it for navigating a year, month, day folder structure where a user can input the start date and have it go to the desired end date. The script will grab a certain file on each day then move onto the next. Ive got all that... (3 Replies)
Discussion started by: Grizzly
3 Replies
6. Shell Programming and Scripting
I’m looking for an elegant way to convert a delimited file (comma delimited in this case) to padded columns (for printing in non-proportional font) but the length of each column is not known ahead of time. It needs to be calculated for each column from the longest entry in that column in a given... (3 Replies)
Discussion started by: Michael Stora
3 Replies
7. Shell Programming and Scripting
Hi,
In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date×tamp. I have to figure out the the data is a date or time stamp or date×tamp.
If it is date then append "<space>00:00:00"... (1 Reply)
Discussion started by: machomaddy
1 Replies
8. 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
9. Shell Programming and Scripting
Hello, here is the outout of the command below.. Can someone please tell me how to get the output as below
output needed:
18914,30716,17051,4139,14155...
( no comma for the last value)
ps -e -o pcpu,pid,user,tty,args | sort -n -k 1 -r | head | awk '{print $2}'
18914
30716
17051
4139... (10 Replies)
Discussion started by: kamathg
10 Replies
10. Shell Programming and Scripting
Is possible to print padded string in printf?
Example
echo 1 | awk '{printf("%03d\n", $1)}'
001I want
S1
S11
S2
S21to be padded as:
S01
S11
S02
S21Thanks! (26 Replies)
Discussion started by: yifangt
26 Replies
LEARN ABOUT CENTOS
sd_journal_get_cutoff_realtime_usec
SD_JOURNAL_GET_CUTOFF_REALTIME_USEC(3) sd_journal_get_cutoff_realtime_usec SD_JOURNAL_GET_CUTOFF_REALTIME_USEC(3)
NAME
sd_journal_get_cutoff_realtime_usec, sd_journal_get_cutoff_monotonic_usec - Read cut-off timestamps from the current journal entry
SYNOPSIS
#include <systemd/sd-journal.h>
int sd_journal_get_cutoff_realtime_usec(sd_journal* j, uint64_t* from, uint64_t* to);
int sd_journal_get_cutoff_monotonic_usec(sd_journal* j, sd_id128_t boot_id, uint64_t* from, uint64_t* to);
DESCRIPTION
sd_journal_get_cutoff_realtime_usec() gets the realtime (wallclock) timestamps of the first and last entries accessible in the journal. It
takes three arguments: the journal context object and two pointers to 64-bit unsigned integers to store the timestamps in. The timestamps
are in microseconds since the epoch, i.e. CLOCK_REALTIME. Either one of the two timestamp arguments may be passed as NULL in case the
timestamp is not needed, but not both.
sd_journal_get_cutoff_monotonic_usec() gets the monotonic timestamps of the first and last entries accessible in the journal. It takes
three arguments: the journal context object, a 128-bit identifier for the boot, and two pointers to 64-bit unsigned integers to store the
timestamps. The timestamps are in microseconds since boot-up of the specific boot, i.e. CLOCK_MONOTONIC. Since the monotonic clock begins
new with every reboot it only defines a well-defined point in time when used together with an identifier identifying the boot, see
sd_id128_get_boot(3) for more information. The function will return the timestamps for the boot identified by the passed boot ID. Either
one of the two timestamp arguments may be passed as NULL in case the timestamp is not needed, but not both.
RETURN VALUE
sd_journal_get_cutoff_realtime_usec() and sd_journal_get_cutoff_monotonic_usec() return 1 on success, 0 if not suitable entries are in the
journal or a negative errno-style error code.
NOTES
The sd_journal_get_cutoff_realtime_usec() and sd_journal_get_cutoff_monotonic_usec() interfaces are available as a shared library, which
can be compiled and linked to with the libsystemd-journal pkg-config(1) file.
SEE ALSO
systemd(1), sd-journal(3), sd_journal_open(3), sd_journal_get_realtime_usec(3), sd_id128_get_boot(3), clock_gettime(2)
systemd 208 SD_JOURNAL_GET_CUTOFF_REALTIME_USEC(3)