Thanks for the information. So many functions covered in one video
@SmartSoftek3 жыл бұрын
Thank you for the nice way of providing the information
@chrisschoeman28002 жыл бұрын
Thanks!
@SteveGriffith-Prof3ssorSt3v32 жыл бұрын
Thank you very much!!!
@shubhampawar4060 Жыл бұрын
itta khush kyo ho gya😃
@brahimnaitdaoud99772 жыл бұрын
how to make a query displaying a condition date withe monthe and day and any year for example you want to display all the dates before black Friday either or before Christmas AND thank you in advence
@ricardoruiz28004 жыл бұрын
When saving a date of birth, should I save also its timezone? It seems to me it does not make any sense and DATE is more appropriate. What do you think?
@SteveGriffith-Prof3ssorSt3v34 жыл бұрын
Date of birth is normally just a date, no time.
@shubhankarsharma22212 жыл бұрын
How to find duration between datetime in hh:mm:ss format ,without tumediff,since it has its limitations?
@SteveGriffith-Prof3ssorSt3v32 жыл бұрын
take the two timestamps and subtract a values from the other. You can convert that into any format you want.
@shubhankarsharma22212 жыл бұрын
@@SteveGriffith-Prof3ssorSt3v3 thanks steve
@Abbici2 жыл бұрын
Hallo. Sorry for the bother. how can i set up a repeat appointment? Imagine doing (also) a school timetable ... Thanks. @}-,-'--------- Gianfranco
@SteveGriffith-Prof3ssorSt3v32 жыл бұрын
You could just have additional columns in your table indicating if it is repeating, the frequency of repeat, the total number or finish date, etc. The only date you need to keep is the start date.
@Abbici2 жыл бұрын
@@SteveGriffith-Prof3ssorSt3v3 So... I don't need another table, right?
@SteveGriffith-Prof3ssorSt3v32 жыл бұрын
@@Abbici There are different ways of doing it but no, you don't have to create another table and create entries for all the repeats.
@Abbici2 жыл бұрын
Ok. I'll try. In the meantime, thank you very much!
@nourhene98653 жыл бұрын
how can i know the time and date of login and logout in my site web or app ??
@SteveGriffith-Prof3ssorSt3v33 жыл бұрын
On your server-side page that processes the login or logout you need to get the current timestamp and save that in the database. In your USERS table where you save their login information have a column that tracks login time and/or logout time. This would give you the most recent values. You can also create a table for SESSIONS / TRACKING where you could save every login, every logout, and every transaction the user has with the database. You can use stored procedures for all your interactions that always include an INSERT into your sessions table. Lots of possibilities.