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
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 tab
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 G
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]
Hi!
> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Wed, Nov 28, 2001 at 01:30:42PM -0800, [EMAIL PROTECTED] wrote:
>>
>> I think while you've got the hood up, a better method of doing the
>> difference between two dates should be derived.
>>
>> Unless I'm going about
ay, November 28, 2001 3:50 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Proposal for two (or more) new time and date functions
>
>
>
> I think while you've got the hood up, a better method of
> doing the difference between two dates should be derived.
>
> Unless I&#x
I think while you've got the hood up, a better method of doing the
difference between two dates should be derived.
Unless I'm going about this all wrong, the only way to get the time
difference between two values currently is:
UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime)
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500:
^
You're quite ahead of me, timewise *G*
> Is there a way to store the time and date that a record was added within
> MySQL? I want to show the time and date on some of my records and can&#x
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500:
> Is there a way to store the time and date that a record was added within
> MySQL? I want to show the time and date on some of my records and can't seem
> to figure out an easy way to do it. Thanks!
Either use a TIMESTAMP
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500:
> Is there a way to store the time and date that a record was added within
> MySQL? I want to show the time and date on some of my records and can't seem
> to figure out an easy way to do it. Thanks!
Either add a timestamp
Add a date/time column and dump the current time into it when you do an
insert
jason
- Original Message -
From: "chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:26 AM
Subject: time and date
> Is there a way to store the ti
Tue, 2 Apr 2002, chris wrote:
> Is there a way to store the time and date that a record was added within
> MySQL? I want to show the time and date on some of my records and can't seem
> to figure out an easy way to do it. Thank
It's in the manual. Check the datatypes section, and the now() mysql
function.
On 4/2/02 6:26 PM, "chris" <[EMAIL PROTECTED]> wrote:
> Is there a way to store the time and date that a record was added within
> MySQL? I want to show the time and date on some of my
Is there a way to store the time and date that a record was added within
MySQL? I want to show the time and date on some of my records and can't seem
to figure out an easy way to do it. Thanks!
-Chris
-
Before posting, p
19 matches
Mail list logo
