Systemdate To Be Used
Mar 30, 2006
I'm new to SQL - so I'd like some help please folks !!!
I have a field in a table which I'd like to update everytime a record is created in this table ???
e.g 'field-created' must be updated with systemdate whenever a record is created in a table called CAR_TRANSACTIONS
How do i do it ????
View 13 Replies
Feb 19, 1999
this might not be considered a sql problem but here goes anyways.
it was 53 weeks in 1998. however it seems like my computer considered week 53 last year as week 1 in 1999.
so when i perform an operation like this:
select datepart(wk, getdate())
next weeks number is returned. what to do?
View 1 Replies
View Related
