Date And Time

[vbGirl]

Hi Friends,


I am facing a small problem, is there any one who can solve that.


My problem is that , i want to increase the time field of my database thru VB programme. how can i do that.



Awaiting for reply


Amit

[Si_the_geek]

get the data out, use the DATEADD function to add to the date/time, then put the data back in to the database again...

[vbGirl]

please if possible give me some code example

thanks

[Si_the_geek]

I think you'd better find a tutorial on working with databases somewhere on the net, preferably one which deals with the database system you are working with (eg: Access/Oracle/SQL Server)

Try this one (on this site):
http://www.vbworld.com/databases/dbtutorial/

[vbGirl]

Hi,

Thanks a lot for your reply

vbGirl

[Jacsoftware]

does the dateadd function work in the sql builder?


dateadd(d,6,?)


It gives me an error!!!!