03-10-2011
first convert the date to the required date format using to_char and specifying the date format u need.. then validate your input using the check constraints.. c if this helps.. even i am new to unix
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I am getting two input from User for Date from the command prompt when
my script is executed .
The date format i am taking is : DD-MM-YYYY
so is there any method in Unix to validate the two input date.
There might be many cases for these two date to be invalid.... (1 Reply)
Discussion started by: rawatds
1 Replies
2. Shell Programming and Scripting
Hi,
I have a date field in my input file.
I just want to check if its in the format "DD-MM-YYYY".
Is there any command which can achieve this?
Thanks and Regards,
Abhishek (2 Replies)
Discussion started by: AAA
2 Replies
3. UNIX for Dummies Questions & Answers
Hi Guru's,
Are there any simple method to check the date format which is in "YYDDD"
(ex: 08002 for 02-Jan-2008)?
Eventhough this can be implemented in several way's, I need the simpler one. Any idea would be much appreciated.
Thanks in advance,
Mysore Ganapati (4 Replies)
Discussion started by: ganapati
4 Replies
4. Shell Programming and Scripting
how to check input date format.
for example $input_date must be in format dd.mm.gg
script is execute like this:
bin/script1.sh 14.12.2009
script1.sh code:
#!/bin/sh
input_date=$1
CMD="/app/si/test/test.sh $input_date"
echo "*****"
$CMD (2 Replies)
Discussion started by: waso
2 Replies
5. Shell Programming and Scripting
I have got few date format patterns like "yyyymmdd", "yy_mm_dd" etc.
There can be any combination of such patterns.
I have used add_delta_days to find "yyyy", "yy", "mm", "dd" for the current date and saved them to different variables like "$y1", "$y2", "$m1" etc
In one line, i want to... (10 Replies)
Discussion started by: irudayaraj
10 Replies
6. Shell Programming and Scripting
I have a filename,
This can be any of any format,
I want to check if the filename has hours,mins and seconds part. If it is present, i want to replace it with a " * " (star symbol)
output needed:
IMP: The time part can be in any pattern.
How can this be done?:confused:... (3 Replies)
Discussion started by: irudayaraj
3 Replies
7. Shell Programming and Scripting
hi there
I have file names in different format as below
triss_20111117_fxcb.csv
triss_fxcb_20111117.csv
xpnl_hypo_reu_miplvdone_11172011.csv
xpnl_hypo_reu_miplvdone_11-17-2011.csv
xpnl_hypo_reu_miplvdone_20111117.csv
xpnl_hypo_reu_miplvdone_20111117xfb.csv... (10 Replies)
Discussion started by: manas_ranjan
10 Replies
8. Shell Programming and Scripting
Hi! how do i know if the input is the same as the required date format? the date should be dd/mm/YYYY ex. 2/3/2012 or 15/11/2012
all the following conditions must return an error:
*input of string
*day is > 31 or < 1
*month is > 12 or < 1
*year is < 2013
suppose the date format is stored... (1 Reply)
Discussion started by: angilulu
1 Replies
9. Shell Programming and Scripting
Hello All,
I have a requirement where i need to get the EXTRACT_DATE from a file and check if the date is of valid format or not and then mail it if it is not valid. Appreciate if you can help me with this.
I did the following so far.
awk '{for(i=1;i++<=NF;)if($i~/^EXTRACT_DATE/) print $i}'... (11 Replies)
Discussion started by: Ariean
11 Replies
10. Shell Programming and Scripting
Record:
Record1|Record2|Record3|Record4|Record5|DATE1|DATE2
Need to Check DATE1 & DATE2 is in DDMMYYYY format in a file.
records which not meet the date format DDMMYYYY extract to other file. (1 Reply)
Discussion started by: vivekn
1 Replies
LEARN ABOUT PHP
datetime.format
DATETIME.FORMAT(3) 1 DATETIME.FORMAT(3)
DateTime::format - Returns date formatted according to given format
Object oriented style
SYNOPSIS
public string DateTime::format (string $format)
DESCRIPTION
string DateTimeImmutable::format (string $format) string DateTimeInterface::format (string $format)
Procedural style
string date_format (DateTimeInterface $object, string $format)
Returns date formatted according to given format.
PARAMETERS
o $object
-Procedural style only: A DateTime object returned by date_create(3)
o $format
- Format accepted by date(3).
RETURN VALUES
Returns the formatted date string on success or FALSE on failure.
EXAMPLES
Example #1
DateTime.format(3) example
Object oriented style
<?php
$date = new DateTime('2000-01-01');
echo $date->format('Y-m-d H:i:s');
?>
Procedural style
<?php
$date = date_create('2000-01-01');
echo date_format($date, 'Y-m-d H:i:s');
?>
The above example will output:
2000-01-01 00:00:00
NOTES
This method does not use locales. All output is in English.
SEE ALSO
date(3).
PHP Documentation Group DATETIME.FORMAT(3)