week number in sql

Question

Hello, I am creating reports using Report Builder and I am looking for how to put the week number / year into a variable.  I can't find the code?  Thank you for your help.  Have a good day  Pascal

jee pee · Answer

Hi,  You didn't specify the RDBMS...  With Oracle: select to_char(sysdate,'WW') from dual;   Best regards         a stranger is a friend you haven't met yet.

pascalou83400 · Answer

Hello jee pee,  I'm a novice and I'm learning to use report builder as best as I can, I don't know what a DBMS is.  My problem is that I'm doing this in a variable and I'm getting an error message on all the codes I try, so I must not be doing things correctly.  I'm entering this code  begin   NumSem = Format(TaDate, "ww", vbMonday, vbFirstFourDays)  end;  error message undeclared label  Do we declare it in a variable or something else?  Thank you for your help.  Pascal

pascalou83400 · Answer

I am under Firebird, is that the DBMS?

jee pee · Answer

Like Mr. Jourdain, you must use a Database Management System without knowing it ;-)  Firebird does seem to be a DBMS; you should look in its SQL for date retrieval commands.  --         a foreigner is a friend we haven't met yet.

jordane45 · Answer

Hello,  Under Firebird (as with others ...), there is a manual and/or tons of tutorials available online that contain most of the answers... :-) Here’s for you: https://firebirdsql.org/refdocs/langrefupd21-intfunc-extract.html  https://firebirdpt.wordpress.com/2005/11/22/date-functions/   Something like  EXTRACT( WEEK FROM CURRENT_DATE );   -- Best regards, Jordane

pascalou83400 · Answer

Hello Jordane45,  Thank you for your help, I looked at the link, but I don’t have the skills to fully understand it, I will still try the code EXTRACT( WEEK FROM CURRENT_DATE );  I put this in a variable in Oncalc  begin   value end; EXTRACT( WEEK FROM CURRENT_DATE );  end;  and this one:   begin  value end; (EXTRACT(YEARDAY FROM D) – EXTRACT(WEEKDAY FROM D-1) + 7) / 7 end;  But no data is coming out.  I don’t know if I’m putting this in the right place.  I continue trying to understand what I’m doing...

Week number in sql

6 answers

Read a facebook video saved as a folder

Startup issue

No sound on my pc

System restore from bootable windows 11 usb drive

My printer won't connect to my pc anymore

Windows 11 microphone issue

File with some lines merged and others not

Notice use techfive dxf00800

Asus vivobook pc won’t boot anymore, need help

Troubleshooting windows 10 pro installation on lenovo