01-11-2013
Ubuntu 12.04 LTS 64 bit. I am using, database is in windows xp os, I have planned extract data from windows pc, and then modify date and time format as I mentioned
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i need date in the following format December 14, 2005.
With date +"%b %d, %Y" command i am getting the following output :- Dec 14, 2005.
can anyone pls tell me how to get the full month name (2 Replies)
Discussion started by: radhika03
2 Replies
2. Shell Programming and Scripting
Date format MM/DD/YYYY
required is YYYYMMDD, I tried using sed but could not get it any help please. (4 Replies)
Discussion started by: mgirinath
4 Replies
3. UNIX for Dummies Questions & Answers
Running bash how do I input the date in the command line like 3/20/90 and get an output formmated like March, 20 1990. (8 Replies)
Discussion started by: knc9233
8 Replies
4. Shell Programming and Scripting
Hi
i need to have the date in the format like dd-mon-yyyy
my script goes like this
#!/usr/bin/bash
for f in /space/can /home/lbs/current/externalcdrbackup/L_CDR_Configuration/1/200903122* ; do
awk '{sum++;}END{for(i in sum) {print d,h,m,i, sum}}' "d=$(date +'%m-%d-%Y')" "h=$(date +'%H')"... (8 Replies)
Discussion started by: aemunathan
8 Replies
5. OS X (Apple)
Hi -
I'm using GeekTool to customize my desktop in OS X 10.5.8
I'm a complete novice as far as UNIX commands, just know enough to be dangerous.
I have a command entered as a Shell to display my events from iCal:
This makes my events show something like this:
While this is... (1 Reply)
Discussion started by: patricksprague
1 Replies
6. Shell Programming and Scripting
Hi,
the date value retrieved by a parameter from the table is of the format dd/mm/yyyy. please let me know how to convert this to YYYYMMDD using sed
thanks (4 Replies)
Discussion started by: swasid
4 Replies
7. Shell Programming and Scripting
Hi all
Y=`date +'%Y'`
M=`date +'%m'`
D=`date +'%d'`
if && ;then
yesterday=$Y$M`expr $D + 30`
echo $yesterday
else
if && ; then
yesterday=$Y$M`expr $D + 29`
echo $yesterday
else
if ; then
yesterday=$Y$M`expr $D + 27`
echo $yesterday
else
yesterday=$Y$M`expr $D - 1`
echo... (8 Replies)
Discussion started by: ultimatix
8 Replies
8. Shell Programming and Scripting
while read l
do
vTimeCreated=`perl -e '@d=localtime ((stat(shift))); printf "%02d-%02d-%04d %02d:% 02d:%02d\n", $d,$d+1,$d+1900,$d,$d,$d' ${l}`
echo "${l} || ${vTimeCreated}" >> ${fPrefx}_Output_Files_${vDate}.txt
done < servername.txt Using the above code to format date time for each of the... (0 Replies)
Discussion started by: HeadBang
0 Replies
9. UNIX for Dummies Questions & Answers
while read l
do
vTimeCreated=`perl -e '@d=localtime ((stat(shift))); printf "%02d-%02d-%04d %02d:% 02d:%02d\n", $d,$d+1,$d+1900,$d,$d,$d' ${l}`
echo "${l} || ${vTimeCreated}" >> ${fPrefx}_Output_Files_${vDate}.txt
done < servername.txt
Using the above code to format date time for each of... (5 Replies)
Discussion started by: HeadBang
5 Replies
10. UNIX for Dummies Questions & Answers
Hi,
How can i store the date + time from the output of the ls command in loop in a variable date1?
-rw-rw---- 1 user1 admin 500002 Jan 2 21:24 P002607.cssI then want to convert Jan 2 21:24 to this date format 2014-01-02 21:24:00 and save it in date2 variable.
Then i would like to add... (1 Reply)
Discussion started by: mohtashims
1 Replies
LEARN ABOUT DEBIAN
wiki-toolkit-revert-to-date
WIKI-TOOLKIT-REVERT-TO-DATE(1p) User Contributed Perl Documentation WIKI-TOOLKIT-REVERT-TO-DATE(1p)
NAME
wiki-toolkit-revert-to-date - Revert the state of a Wiki::Toolkit instance to an earlier point in time.
SYNOPSIS
# Removes any changes made to a Wiki::Toolkit instance since a given date
# (and optionally time), restoring it to the state at that point.
wiki-toolkit-revert-to-date --type postgres
--name mywiki
--user wiki
--pass wiki
--host 'db.example.com'
--port 1234
--date 2007-01-05
--time 11:23:21
DESCRIPTION
Takes three mandatory arguments:
type
The database type. Should be one of 'postgres', 'mysql' and 'sqlite'.
name
The database name.
date
The date to revert the state back to, in the format YYYY-MM-DD
five optional arguments:
time
The time (on the specified date) to revert the state back to, in the format hh:mm:ss. If not specified, will use midnight.
user
The user that connects to the database. It must have permission to create and drop tables in the database.
pass
The user's database password.
host
The hostname of the machine the database server is running on (omit for local databases).
port
The port number that the database server is expecting connections to.
AUTHOR
Nick Burch
COPYRIGHT
Copyright (C) 2006 Nick Burch. All Rights Reserved.
This code is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
Wiki::Toolkit
perl v5.14.2 2011-09-25 WIKI-TOOLKIT-REVERT-TO-DATE(1p)