MySQL DayofWeek And Weekday Functions

DayOfWeek
------------------

Returns the weekday index for date (1 = Sunday, 2 = Monday, …, 7 = Saturday). These index values correspond to the ODBC standard.

Weekday
------------

0 = Monday , 1 = Tuesday, 2 = Wednesday, ...... Sunday = 6).

DayName
------------
Weekday name of the date.

Kommentare

Beliebte Posts aus diesem Blog

How to - Web browser Control

Creating a simple HTML Editor using Web brower control Create a basic Winform Appln. Drag a Webbrowser( end in the list ) from Toolbox. To create buttons drag a Toolstrip control (near webbrowser ctrl in the list 'Commoncontrols' ) from Toolbox. You can add buttons, text box, progressbar etc by clicking. c To make the Web browser control editable you have to write the following code while initializing. InitializeComponent(); webBrowser1.DocumentText = "<HTML><BODY contentEditable='true'></BODY></HTML>"; toolStripComboFontSize.SelectedIndex = 2; Double click on buttons to generate events. Variable possibilities are there . Some are given below, 1. Change text color if (colorDialog1.ShowDialog() == DialogResult.OK) ...

Select the rows depending upon the occurence

SELECT `id` FROM table GROUP BY id HAVING COUNT(*) = 1 id column1 column2 -------------------------- 1 value1 value2 1 value1 value2 2 value1 value2 Executing the above query will get a result id --- 2 while occurence of the id = 2 is only once

Floating Webbrowser control Images

foreach (HtmlElement im in webBrowser1.Document.Images) { im.Style="FLOAT:left;"; }

My Tech Blog

Dieses Blog durchsuchen