Hi there I have a file that I recieve that looks like the folowing, As these details are being manually entered by the customer, we sometimes get a few typos on 4th column (the 14 digit number starting with 42....) As you can see the first one has a space as the first character and then a 13 number... (3 Replies)
I want a sample Date validation script using if loops.
The script should first compare "year".If the year is lesser than the current year,It should go for "month" checking.
I have the script that splits the date into year,month and date.I want only the checking part.
My if loop checking is not... (4 Replies)
Hi
I have below file with 3 rd column as date ....i want to make 3 column to mm/dd/yyyy .
in the below file 2 row date is like 1/23/1994 so i want to append '0'
to month i,e. 01/23/1994 and in the 3 row date is like 6/4/1994 ---so i want this to 06/04/1994
Source:... (1 Reply)
Hi all,
I have a pecular issue in sorting these files (not an ls -lrt) in Solaris environment.
All the below files are modified on November 4th, but I want to sort these files as per date (eg: 01May07_1623 = ddmmmyy_hhmm)
Nov 4 18:27 SONYELEC00.GI22973.01May07_1623.gpg
Nov 4 18:27... (10 Replies)
the user have to input the date format in mmddmmhhyyyy (month,date,minutes,hour,year)
i want a shell script to check whether the user has properly input in the above said manner.
kindly advice (2 Replies)
Hi,
I have a script which runs on specific sunday. If that script runs on the sunday i want to execute another script on following wednesday.
I have a log for that server. My wednesday scripts needs to check the sunday run log timestamp and if it matches it should run. Please help.
Thanks,... (1 Reply)
Dears,
I am working on a batch that processes file with name containing date prefix eg., 20101222_file.dat.
The logic is to process files in order. Eg., 20101225 must be processed only after 20101222.
Ok first glance it looked simple, it use a variable to check this date value as number and... (2 Replies)
File contains below data,how to validate the date using awk command or any command.
date formate is fixed as "YYYYMMDD"
test1|20120405
test2|20121405
output should be:
test1|20120405
Thanks (2 Replies)
I'm writing a shell script for cleanup of older files from various sub-directories inside a main directory
The structure of directories is as below:
Logs
daily
online
archive
weekly
online
archive... (1 Reply)
Hi folks,
I new to shell script .
I want to know how to validate a String as valid date
example:
20150712 ---> valid date
20160524-->valid
201605T12-->invalid date
12341234--->invalid date
we need to valid string( yyyymmdd) to date in SunOS 5.10
please give some idea to validate... (9 Replies)
Discussion started by: srinadhreddy27
9 Replies
LEARN ABOUT PHP
db2_field_scale
DB2_FIELD_SCALE(3) 1 DB2_FIELD_SCALE(3)db2_field_scale - Returns the scale of the indicated column in a result setSYNOPSIS
int db2_field_scale (resource $stmt, mixed $column)
DESCRIPTION
Returns the scale of the indicated column in a result set.
PARAMETERS
o $stmt
- Specifies a statement resource containing a result set.
o $column
- Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a
string containing the name of the column.
RETURN VALUES
Returns an integer containing the scale of the specified column. If the specified column does not exist in the result set,
db2_field_scale(3) returns FALSE.
SEE ALSO db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_type(3), db2_field_width(3).
PHP Documentation Group DB2_FIELD_SCALE(3)