Hi All,
how to Get file modified time and date of file by using builtin function or
procedure in sql?
Thanks,
Siva
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
which file are u talking about.
regards
anandkl
On 7/24/08, Sivasakthi [EMAIL PROTECTED] wrote:
Hi All,
how to Get file modified time and date of file by using builtin function or
procedure in sql?
Thanks,
Siva
--
MySQL General Mailing List
For list archives:
Ananda Kumar wrote:
which file are u talking about.
regards
anandkl
Ordinary temp file.. say example in C:\output.txt
Actually i have given that file as input to some procedure, based on
that modification time we have calculate some details.
--
MySQL General Mailing List
For list
you can do that using OS command, any specific reason u want to use stored
proc to get this information.
On 7/24/08, Sivasakthi [EMAIL PROTECTED] wrote:
Ananda Kumar wrote:
which file are u talking about.
regards
anandkl
Ordinary temp file.. say example in C:\output.txt
Actually i
Ananda Kumar wrote:
you can do that using OS command, any specific reason u want to use
stored proc to get this information.
OS Command? could you explain with examples? because, I have more # of
input files.. thats why iam going to procedure..
--
MySQL General Mailing List
For list
If windows u can use
dir file_name
Volume in drive C has no label.
Volume Serial Number is 9822-5D20
Directory of C:\
07/26/2005 02:26 AM 1,442 archival_s.pls
1 File(s) 1,442 bytes
0 Dir(s) 5,230,874,624 bytes free
in unix
ls -ltr
how to Get file modified time and date of file by using builtin
function or procedure in sql?
On Codd's rules, it oughtn't to be possible---it'd be a backdoor. If
there is a need to know the datetime of the last mod to a table, that
info ought to be in a column in a table.
PB
--
MySQL
Sivasakthi wrote:
Ananda Kumar wrote:
which file are u talking about.
regards
anandkl
Ordinary temp file.. say example in C:\output.txt
Actually i have given that file as input to some procedure, based on
that modification time we have calculate some details.
It sounds like you are
On Thu, Jul 24, 2008 at 1:17 AM, Sivasakthi [EMAIL PROTECTED] wrote:
Hi All,
how to Get file modified time and date of file by using builtin function or
procedure in sql?
In a related thread from earlier today you were advised that any
interaction with the filesystem should be done via a