bash date format


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers bash date format
# 1  
Old 04-01-2008
bash time format

hi guys.

in bash is there any other way of limiting the time displayed to HH:MM

appart from

(date +"%H:%M") and (date +"%R")?

i want to input time into a database in the form HH:MM

have tried NOW() but this gives me HH:MM:SS

thanks in advance

Last edited by vadharah; 04-01-2008 at 08:47 AM.. Reason: spelling
# 2  
Old 04-01-2008
What database? Most of them have something like this (Oracle example)
Code:
update sometable
set somefld=to_char(sysdate,"HH:MI");
COMMIT;

that you can run from a commandline tool like sqlplus.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date: invalid date trying to set Linux date in specific format

i try to set linux date & time in specific format but it keep giving me error Example : date "+%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01" or date +"%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01" keep giving me this error : date: invalid date ‘19-01-2017 00:05:01' Please use CODE tags... (7 Replies)
Discussion started by: umen
7 Replies

2. Shell Programming and Scripting

Bash Scripting with date format conversion

I have a script below and wanted to change the output into three different file format (3 separate script) #!bin/bash #input file format postwrf_d01_20131206_0600_f08400.grb2 #postwrf_d01_YYYYMMDD_ZZZZ_f0HHHH.grb2 #zzzz= 0000,0600,1200,1800 (in UTC) #HHHH=00000,00600,01200,01800 ..ect (in... (1 Reply)
Discussion started by: cumulus_255
1 Replies

3. UNIX for Dummies Questions & Answers

Rename all Files in a UNIX Directory from one date format to another date format

Hi Unix Gurus, I would like to rename several files in a Unix Directory . The filenames can have more than 1 underscore ( _ ) and the last underscore is always followed by a date in the format mmddyyyy. The Extension of the files can be .txt or .pdf or .xls etc and is case insensitive ie... (1 Reply)
Discussion started by: pchegoor
1 Replies

4. UNIX for Dummies Questions & Answers

Date format in Bash Script

Hi Experts I'm struggling with the dates in bash scripting. here is my code due1=`grep "$member" Due.txt | tail -n 1 | cut -d "," -f2 | tr -d "\15"` duedate1=`date +%Y-%m-%$due1` echo $due1 echo $duedate1 if I execute the above code I get output as 10 2013-09 %10 ... (2 Replies)
Discussion started by: parpaa
2 Replies

5. UNIX for Dummies Questions & Answers

Date format in Bash Script

Hi Experts, We get "Day" of a month in a variable, so how to make date of out it? To make more sense if my variable $DAY contains "12" and month and year will be current date (as of today) so I want to see as output as 2013-09-12. How can I achive this bash script?? Any help is... (4 Replies)
Discussion started by: parpaa
4 Replies

6. Shell Programming and Scripting

How to format string/date in bash?

I have string like "1-JUN-11" and it needs to be converted to "01JUN11" and "1/6/2011":confused::confused::confused: Thanks (2 Replies)
Discussion started by: ford99
2 Replies

7. Shell Programming and Scripting

How to increment a user defined date value in the DATE format itself using shell script?

I need to increment a date value through shell script. Input value consist of start date and end date in DATE format of unix. For eg. I need increment a date value of 1/1/09 to 31/12/09 i.e for a whole yr. The output must look like 1/1/09 2/2/09 . . . 31/1/09 . . 1/2/09 . 28/2/09... (1 Reply)
Discussion started by: sunil087
1 Replies

8. UNIX for Dummies Questions & Answers

Changing from Excel date format to MySQL date format

I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd. The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4". This is what I use to change the format: sed -i '' -e... (2 Replies)
Discussion started by: figaro
2 Replies

9. Shell Programming and Scripting

convert date format to mysql date format in log file

I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column. I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this? Sample input 02/27/09,23:52:31 02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies

10. Shell Programming and Scripting

convert mmddyy date format to ccyyddd format??

hi, for reading a cobol indexed file i need to convert "mmddyy" date format to "ccyyddd" format. i checked the datecalc and other scripts but couldnt modify them to cater to my need:(... The datecalc gives an output which i believe is the total days till that date, but i want to convert it... (2 Replies)
Discussion started by: Bhups
2 Replies
Login or Register to Ask a Question