Time question - add 15 minutes

[Digit24]

I have a time field in an access database and I want to be able to add 15
minutes to it.

I can do this manually by taking the minute, adding 15 and then if it is
over 60, changing the hour, but is there an easier way like with adding a
day to a date by simply adding 1?

Many thanks

[Evertjan.]

Digit24 wrote on 29 apr 2004 in microsoft.public.inetserver.asp.db:

> I have a time field in an access database and I want to be able to add 15
> minutes to it.
>
> I can do this manually by taking the minute, adding 15 and then if it is
> over 60, changing the hour, but is there an easier way like with adding a
> day to a date by simply adding 1?
>

Using MS jet engine you will have to use a plain ASP-vbs loop, I think,
with:


newdatetime = DateAdd("n",olddatetime,15)

["n" for minute, "m" for month]

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Bob Barrows [MVP]]

Digit24 wrote:

> I have a time field in an access database and I want to be able to
> add 15 minutes to it.
>
> I can do this manually by taking the minute, adding 15 and then if it
> is over 60, changing the hour, but is there an easier way like with
> adding a day to a date by simply adding 1?
>
> Many thanks

UPDATE table
SET [datefield] = DATEADD("n",15,[datefield])
WHERE <primarykeyfield(s) = some criterial)

HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Roland Hall]

"Evertjan." wrote in message news:Xns94DA810A1744Feejj99@194.109.133.29...
: Digit24 wrote on 29 apr 2004 in microsoft.public.inetserver.asp.db:
:
: > I have a time field in an access database and I want to be able to add
15
: > minutes to it.
: >
: > I can do this manually by taking the minute, adding 15 and then if it is
: > over 60, changing the hour, but is there an easier way like with adding
a
: > day to a date by simply adding 1?
: >
:
: Using MS jet engine you will have to use a plain ASP-vbs loop, I think,
: with:
:
:
: newdatetime = DateAdd("n",olddatetime,15)
:
: ["n" for minute, "m" for month]

DateAdd Syntax: DateAdd(interval, number, date)

The interval argument can have the following values:
Setting Description
yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week of year
h Hour
n Minute
s Second

newdatetime = DateAdd("n", 15, now)

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - [url]http://www.microsoft.com/technet/scriptcenter/[/url]
WSH 5.6 Documentation - [url]http://msdn.microsoft.com/downloads/list/webdev.asp[/url]
MSDN Library - [url]http://msdn.microsoft.com/library/default.asp[/url]

[Evertjan.]

Bob Barrows [MVP] wrote on 29 apr 2004 in
microsoft.public.inetserver.asp.db:

> Digit24 wrote:

>> I have a time field in an access database and I want to be able to
>> add 15 minutes to it.
>>
>> I can do this manually by taking the minute, adding 15 and then if it
>> is over 60, changing the hour, but is there an easier way like with
>> adding a day to a date by simply adding 1?
>>
>> Many thanks

>
> UPDATE table
> SET [datefield] = DATEADD("n",15,[datefield])
> WHERE <primarykeyfield(s) = some criterial)

Can the jet engine do that?


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Bob Barrows [MVP]]

Evertjan. wrote:

> Bob Barrows [MVP] wrote on 29 apr 2004 in
> microsoft.public.inetserver.asp.db:
>

>> Digit24 wrote:

>>> I have a time field in an access database and I want to be able to
>>> add 15 minutes to it.
>>>
>>> I can do this manually by taking the minute, adding 15 and then if
>>> it is over 60, changing the hour, but is there an easier way like
>>> with adding a day to a date by simply adding 1?
>>>
>>> Many thanks

>>
>> UPDATE table
>> SET [datefield] = DATEADD("n",15,[datefield])
>> WHERE <primarykeyfield(s) = some criterial)

>
> Can the jet engine do that?

Yes. The Jet engine is able to utilize quite a few VBA functions. There are
several which are considered "unsafe" and therefore not allowed (Replace,
IIF, Nz, etc), but DATEADD is not restricted. You can see the list here:
[url]http://support.microsoft.com/?id=294698[/url]

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Evertjan.]

Bob Barrows [MVP] wrote on 29 apr 2004 in
microsoft.public.inetserver.asp.db:

> Yes. The Jet engine is able to utilize quite a few VBA functions.
> There are several which are considered "unsafe" and therefore not
> allowed (Replace, IIF, Nz, etc), but DATEADD is not restricted. You
> can see the list here: [url]http://support.microsoft.com/?id=294698[/url]

Interesting, thanks.

So I could write:

SQL = "UPDATE tblX SET Dat = DateAdd("h",1,Dat)"

to correct a whole column of field "Dat"?

Is the "SELECT Dat" action intrinsic to UPDATE?

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Bob Barrows [MVP]]

Evertjan. wrote:

> Bob Barrows [MVP] wrote on 29 apr 2004 in
> microsoft.public.inetserver.asp.db:
>

>> Yes. The Jet engine is able to utilize quite a few VBA functions.
>> There are several which are considered "unsafe" and therefore not
>> allowed (Replace, IIF, Nz, etc), but DATEADD is not restricted. You
>> can see the list here: [url]http://support.microsoft.com/?id=294698[/url]

>
> Interesting, thanks.
>
> So I could write:
>
> SQL = "UPDATE tblX SET Dat = DateAdd("h",1,Dat)"
>
> to correct a whole column of field "Dat"?

Absolutely. It's safer to surround the column name with brackets, but the
idea is correct.

>
> Is the "SELECT Dat" action intrinsic to UPDATE?

Sorry, but I'm not sure about what you mean by "SELECT Dat" in relation to
UPDATE queries.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Evertjan.]

Bob Barrows [MVP] wrote on 29 apr 2004 in
microsoft.public.inetserver.asp.db:

>> SQL = "UPDATE tblX SET Dat = DateAdd("h",1,Dat)"
>>
>> to correct a whole column of field "Dat"?

>
> Absolutely. It's safer to surround the column name with brackets, but the
> idea is correct.

>> Is the "SELECT Dat" action intrinsic to UPDATE?

>
> Sorry, but I'm not sure about what you mean by "SELECT Dat" in
> relation to UPDATE queries.
>

UPDATE, to my simple mind, was a "write to database" action.

SELECT a "read from database" action.

Now it seems UPDATE can "read-change-write" in one go.

[The name "UPDATE" should have informed me]

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Chris Hohmann]

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23$Vn6lfLEHA.4052@TK2MSFTNGP11.phx.gbl...

> Evertjan. wrote:

> > Bob Barrows [MVP] wrote on 29 apr 2004 in
> > microsoft.public.inetserver.asp.db:
> >

> >> Digit24 wrote:
> >>> I have a time field in an access database and I want to be able to
> >>> add 15 minutes to it.
> >>>
> >>> I can do this manually by taking the minute, adding 15 and then if
> >>> it is over 60, changing the hour, but is there an easier way like
> >>> with adding a day to a date by simply adding 1?
> >>>
> >>> Many thanks
> >>
> >> UPDATE table
> >> SET [datefield] = DATEADD("n",15,[datefield])
> >> WHERE <primarykeyfield(s) = some criterial)

> >
> > Can the jet engine do that?

>
> Yes. The Jet engine is able to utilize quite a few VBA functions.

There are

> several which are considered "unsafe" and therefore not allowed

(Replace,

> IIF, Nz, etc), but DATEADD is not restricted. You can see the list

here:

> [url]http://support.microsoft.com/?id=294698[/url]

IIF is allowed. Let's hope that never changes. :) Also it's worth
mentioning that the referenced article in not really applicable to ASP,
but is geared more towards sandboxing user defined function from
external access. For example a call from a Visual Basic app. Remember
this thread?...

[url]http://groups.google.com/groups?threadm=eM7hCy64DHA.2404%40TK2MSFTNGP12.phx .gbl[/url]

HTH
-Chris Hohmann

[Bob Barrows [MVP]]

Evertjan. wrote:

> Bob Barrows [MVP] wrote on 29 apr 2004 in
> microsoft.public.inetserver.asp.db:

>>> SQL = "UPDATE tblX SET Dat = DateAdd("h",1,Dat)"
>>>
>>> to correct a whole column of field "Dat"?

>>
>> Absolutely. It's safer to surround the column name with brackets,
>> but the idea is correct.

>
>

>>> Is the "SELECT Dat" action intrinsic to UPDATE?

>>
>> Sorry, but I'm not sure about what you mean by "SELECT Dat" in
>> relation to UPDATE queries.
>>

>
> UPDATE, to my simple mind, was a "write to database" action.
>
> SELECT a "read from database" action.
>
> Now it seems UPDATE can "read-change-write" in one go.
>
> [The name "UPDATE" should have informed me]

I still don't see the word "SELECT" in the example UPDATE statement. But as
far as that goes, there is nothing preventing you from using a subquery in
an UPDATE statement:

UPDATE sometable
SET somefield = (SELECT somefield FROM othertable WHERE ...)
WHERE ...

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[fuzzysoftware@calfordgreen.com]

Yes you do it exactly like adding 1 to th date. In ASP, date and time are all one field, they are not 2 separate fields as in other environments (that I work in anyway). So if adding 1 day is done by " now + 1 " then adding 1 hour would be 1/24th of a day, ie " now + (1/24 * 1) " and 15 minutes might be
" now + ( (1/24) / 60 ) * 15 ". Did it that way to show the calculation, but you can do it various different ways, but the priciple is fractions of 1 day.

Hope this helps
Marcus

************************************************** ********************
Sent via Fuzzy Software @ [url]http://www.fuzzysoftware.com/[/url]
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...