by: Solomon Grundy |
last post by:
Select trunc(sysdate,'MM')
from dual
of course gives me the first day of the month, may I ask what the
query is to find the first saturday of the month?
|
by: CrystalDBA |
last post by:
I am using SQL Server 2000. I need to query my database for all the
contracts that came in during a certain time frame (user is prompted
for reportingperiodid).
Table - Periods
Fields -...
|
by: Jerry |
last post by:
Given a selected date, how do I find the date of the Sunday and Saturday of
the week that that date is in?
Thanks!
Jerry
|
by: Hardy Wang |
last post by:
Hi:
Are there any algorithms I can use, that based on a given date and a
culture code (different cultures may have different beginning of week), I
can get first and last date of the current week?...
|
by: Chris Hill via .NET 247 |
last post by:
Hi
I'm a jnr developer in need of desparate help. Can anyone point me in the right direction for this problem:
I calculate the number of days between 2 user defined dates like this:
Dim...
|
by: griemer |
last post by:
Hi every one,
Is there a way to calculate the timestamp of 00:00:00 last Sunday. For
me, this is the begin of the current week..
Or, how old is this week, in seconds
Any ideas?
Regards,
|
by: foxykitty |
last post by:
Hi,
How can I group in my qryMonthlyHours in SQL view by , and then sum done in that month?
I have another query - qrySaturdayRota
,,,,, ALL THIS IS GROUPED EXCEPT FOR
has a criteria...
|
by: khicon73 |
last post by:
Hello All,
I would like to calculate weeknumber and period from first day of the week (sunday) and last day of the week (saturday) and week number falls from 1 to 52 only. If week number >= 53 then...
|
by: muddasirmunir |
last post by:
i am using vb6. what i need is to calculate X (means any ) working day
date skipping holidays (saturday and sunday) or (friday or saturday in some contries)
for example:
today is 20-06-2008...
|
by: Mike |
last post by:
Is there a way to calculate the total number of weekdays when provided a
date?
Example:
If I have a start date of 7/11/2008 and I want to go out 10 days, I want to
get this:
6 weekdays
4...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|