Re: sql date question

2013-07-31 Thread white jeff
'where backup_date=current_timestamp - 3 days' or 'where backup_date>current_timestamp - 3 hours' or 'where (backlup_date between '2013-07-01 12:00:00' and '2013-07-01 18:00:00') On 31 July 2013 16:22, Lee, Gary wrote: > Not sure where to look for this answer, so a pointer wil work as well. >

sql date question

2013-07-31 Thread Lee, Gary
Not sure where to look for this answer, so a pointer wil work as well. I want to show files backed up for a node on a particular date. However, the date stamp is a bit unwieldy to use. How can I say something like files backed up today - 3 or today - 2? I know that durrent_date is today. Than

Re: Date question

2002-04-10 Thread Denzel, Richard van
All, I'll get back on this when our tape-mount problem is fixed. Richard. -Original Message- From: Alex Paschal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 7:31 PM To: [EMAIL PROTECTED] Subject: Re: Date question Actually, unless I'm mistaken, if that'

Re: Date question

2002-04-10 Thread Alex Paschal
Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 5:50 AM To: [EMAIL PROTECTED] Subject: Re: Date question I concur. You can't ignore the "server out of storage space"

Re: Date question

2002-04-10 Thread Andrew Raibeck
" <[EMAIL PROTECTED]> 04/10/2002 02:17 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:Re: Date question Richard, Output of your dsmsched.log says your scheduled event 'B18' was failed. I believe

Re: Date question

2002-04-10 Thread Mahesh Prasad
ave a problem with our tape drive, which can't mount any tapes anymore (PMR 91056). Richard. -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 5:06 PM To: [EMAIL PROTECTED] Subject: Re: Date question Can't you provide the info from l

Re: Date question

2002-04-10 Thread Denzel, Richard van
, because we have a problem with our tape drive, which can't mount any tapes anymore (PMR 91056). Richard. -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 5:06 PM To: [EMAIL PROTECTED] Subject: Re: Date question Can't you provide the

AW: Date question

2002-04-09 Thread Stefan Holzwarth
Richard van [mailto:[EMAIL PROTECTED]] > Gesendet: Dienstag, 9. April 2002 15:29 > An: [EMAIL PROTECTED] > Betreff: Date question > > > Hi All, > > I have a question about the backup dates. I've seen the > following behaviour which I can't explain: > > W

Re: Date question

2002-04-09 Thread Andrew Raibeck
: [EMAIL PROTECTED] cc: Subject:Re: Date question Andrew, My schedule is running again at 18:00 (GMT+1), I will let you know tomorrow. Richard. -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 4:10 PM To: [EMAIL

Re: Date question

2002-04-09 Thread Denzel, Richard van
Andrew, My schedule is running again at 18:00 (GMT+1), I will let you know tomorrow. Richard. -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 4:10 PM To: [EMAIL PROTECTED] Subject: Re: Date question It would help to have additional

Re: Date question

2002-04-09 Thread PINNI, BALANAND (SBCSI)
What is the randomization time u set .Need to look into that I think. What %age? Balanand -Original Message- From: Denzel, Richard van [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 9:00 AM To: [EMAIL PROTECTED] Subject: Re: Date question No, the schedules are started at the

Re: Date question

2002-04-09 Thread Andrew Raibeck
2 07:00 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:Re: Date question No, the schedules are started at the correct date/time. After the schedule completes the date on the clients filespaces doesn't get updated to

Re: Date question

2002-04-09 Thread Elenara Geraldo
Hi, Verify the status/scheduler it's finished with sucess. With the command below: q even * * Maybe, appear an error. --- Regards, Elenara Geraldo Analyst Support MML Systems Phone: 55 41-342-7864 E-mail: [EMAIL PROTECTED] On Tue, 9 Apr 2002 15:28:37 Denzel, Richard van wrote: >Hi All, > >

Re: Date question

2002-04-09 Thread Denzel, Richard van
002 3:42 PM To: [EMAIL PROTECTED] Subject: Re: Date question Hi, Verify the status/scheduler it's finished with sucess. With the command below: q even * * Maybe, appear an error. --- Regards, Elenara Geraldo Analyst Support MML Systems Phone: 55 41-342-7864 E-mail: [EMAIL PROTECTED] On

Date question

2002-04-09 Thread Denzel, Richard van
Hi All, I have a question about the backup dates. I've seen the following behaviour which I can't explain: When I make a manual backup of a client, the dat on the filespace gets set. When the next day a backup is made through a schedule, the filespace date doesn't get updated. Has anyone seen