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
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 usi
>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 Gene
If windows u can use
dir
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
ls -ltr abc.
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 archives
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
>
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 archiv
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: http:/