Change format of date in vb.net I want to change the format of a date in vb.net so I can insert it in a MySQL table.  my code:  LblDateInc.Text = Date.Today   result: 10/18/2017  in mysql table the column date need to look like this: 2017/10/18  so how to change the format of the date in vb.net or in mysql thank you
format date in c# How can I format a date as dd/mm/yyyy or mm/dd/yy ?   Like in VB format("dd/mm/yy",now)  How can I do this in C#?
I have to create a report on some student completions. The students each belong to one client. Here are the tables (simplified for this question).  CREATE TABLE  `clients` (   `clientId` int(10) unsigned NOT NULL auto_increment,   `clientName` varchar(100) NOT NULL default '',   `courseNames` varchar(255) NOT NULL default '' )   The courseNames field holds a comma-delimited string of course names, eg "AB01,AB02,AB03"  CREATE TABLE  `clientenrols` (   `clientEnrolId` int(10) unsigned NOT NULL auto_increment,   `studentId` int(10) unsigned NOT NULL default '0',   `courseId` tinyint(3) unsigned NOT NULL default '0' )   The courseId field here is the index of the course name in the clients.courseNames field. So, if the client's courseNames are "AB01,AB02,AB03", and the courseId of the enrolment is 2, then the student is in AB03.  Is there a way that I can do a single select on these tables that includes the course name? Keep in mind that there will be students from different clients (and hence have different course names, not all of which are sequential,eg: "NW01,NW03")  Basically, if I could split that field and return a single element from the resulting array, that would be what I'm looking for. Here's what I mean in magical pseudocode:  SELECT e.`studentId`, SPLIT(",", c.`courseNames`)[e.`courseId`] FROM ... Let $\{X_\alpha\}_{\alpha\in J}$ be a family of topological spaces and let $X=\prod_{\alpha\in J}X_\alpha$ be endowed with the product topology. Show that $X$ is path connected if and only if each $X_\alpha$ is path connected.  I know this is true if path coennected is changed by connection but I am very confused with this problem, I have tried to do the following:  $\Rightarrow $ let $x,y \in X_\alpha$ be then $(x_\alpha), (y_\alpha)\in \prod X_\alpha$ where $x_\alpha=x, y_\alpha=y$ and $x_\beta=0, y_\beta=0$ for any $\beta\neq\alpha$, and since P is path connected then there is continuous $f:[0,1]\rightarrow \prod X_\alpha$ such that $f(0)=(x_\alpha)$ and $f(1)=(y_\alpha)$, then if $\pi_\alpha:\prod X_\alpha \rightarrow X_\alpha$ is the projection, which is continuous, we have that $\pi_\alpha f:[0,1]\rightarrow X_\alpha$ is continuous and $\pi_\alpha (f(0))=x$ and $\pi_\alpha (f(1))=y$.  $\Leftarrow$ I do not know how to do this address, could someone help me please? Thank you very much. I have the Ubuntu WSL2, is it possible to run games like nSnake? how would i install it? Title says all. I have ubuntu 20.04 LTS. I downloaded it from the Microsoft store, and i was to install games on it. How do i do this? How to properly unwrap my mesh? Is there a way to automatically unwrap my character? If not, is there a tutorial or something? I have played the game Othello (Reversi) numerous times but I never approach it with a specific logic or algorithm to apply on each move in my mind. I won many times and lost as much. How would one approach this game? How would one work in his mind to prune the possible moves and choose the &quot;right&quot; one in each step? I see that most Othello CPUs more or less &quot;think&quot; the same at each move, how should I think on each move? Traces of all positive powers of a matrix are zero implies it is nilpotent Let $A$ be an $n\times n$ complex nilpotent matrix. Then we know that because all eigenvalues of $A$ must be $0$, it follows that $\text{tr}(A^n)=0$ for all positive integers $n$.  What I would like to show is the converse, that is,      if $\text{tr}(A^n)=0$ for all positive integers $n$, then $A$ is nilpotent.   I tried to show that $0$ must be an eigenvalue of $A$, then try to show that all other eigenvalues must be equal to 0. However, I am stuck at the point where I need to show that $\det(A)=0$.  May I know of the approach to show that $A$ is nilpotent? Uniformly Continuous Function sending Bounded Set to Unbounded One Let $(X,d)$ and $(Y,\rho)$ be metric spaces, and let $f: X \to Y$ be a uniformly continuous function. If $A \subset X$ is bounded, must $f(A) \subset Y$ be bounded?  It is clear to me that in metric spaces that satisfy the Heine-Borel property, such as $\mathbb{R}^{n}$, the answer to this question is yes. However, I can see no reason why this should hold for arbitrary metric spaces. Any ideas? Thanks! Layover in Europe to the US - allowed? Many people have asked questions on this site regarding the rules for layovers, with no definitive answers. The rules are constantly in flux and it is very difficult to get a clear answer from government websites. I would like to buy a plane ticket for my mother-in-law (who has a visa) from Ukraine to the US. Most available flights have at least one layover in Europe. My understanding is that EU countries (minus some special cases and US citizens) are currently banned from travel to the US. If we buy a ticket with a layover in, say, Switzerland, can there be a problem? Is this allowed under current rules? So I integrate the holomorphic function $\frac{e^{iz} -1}{iz}$ over the half disk in the upper half plane, let me name it $\Gamma$. By using Cauchy's theorem, it equals 0.  $$0 = \int_{\Gamma} \frac{e^{iz} -1}{iz} = \int_{0}^{\pi}(e^{iRe^{i\theta}}-1)d\theta + \int_{-R}^{R} \frac{e^{it}-1}{it}dt$$  ($Re^{[0, \pi]}$ and $t: [-R, R]$ being the respective parametrizations.)  By splitting the left integral in two, I get $\int_{0}^{\pi} e^{iRe^{i\theta}}d\theta \rightarrow 0$ by dominated convergence, and $\int_{0}^{\pi} -1d\theta = -\pi$. By making $R \rightarrow \infty$, I'm left with  $$\pi = \int_{-\infty}^{\infty} \frac{e^{it} - 1}{it}dt = \int_{-\infty}^{\infty}\frac{\sin t}{t}dt + \int_{-\infty}^{\infty}\frac{\cos t -1}{it}dt.$$  How do I get rid of the integral on the right? I welcome all feedback. When should a supervisor be an author? How to get business map location displayed in the right hand sidebar of the Google search results page? Does anyone know how to get your business map location displayed in the right hand sidebar of the Google search results page? As in the screenshot below:      I already added my business to this link: .  Is adding detail in above link enough or do I need to change my website coding? Are there any tools for Windows 7 that will allow me to enable/disable monitors from the command-line?  For example, my GTX 480 has three outputs (2x DVI and 1x HDMI) but only two displays can be active at any given time.  I'd like for a command-line to allow me to disable one of the DVI monitors and enable the HDMI monitor, etc.  (I've found NirCmd which is an amazing utility but it doesn't seem to support this...)  EDIT: UltraMon seems capable of doing this but I really hoping for a more light-weight command-line solution... Is it correct that "etc." can not be used together in a sentence with "for example" and "such as"? I just read an article from a Chinese website for English teaching which mentions  that point. For instance, one can't say:     "I can play quite a few musical instruments, for example, the flute, the guitar, the piano, etc.".    The correct one should be:     "I can play quite a few musical instruments, for example, the flute, the guitar, and the piano."    Is it possible to find any references to prove that? I had created the xml document with xml version="1.0".  In that document I need to use the greater than symbol &gt; and less than symbol &lt;.  How should I include those symbols? It's not working.  &amp;gt; and &amp;lt; are not working for me.  Is there any special encoder for this? Standard concise way to copy a file in Java? What command can I type into the Terminal so that I can delete all .svn folders within a folder (and from all subdirectories) but not delete anything else? How to install with Wubi when it says "Could not retrieve the required disk image files"? How well will WCF scale to a large number of client users? Does anyone have any experience with how well web services build with Microsoft's WCF will scale to a large number of users?  The level I'm thinking of is in the region of 1000+ client users connecting to a collection of WCF services providing the business logic for our application, and these talking to a database - similar to a traditional 3-tier architecture.   Are there any particular gotchas that have slowed down performance, or any design lessons learnt that have enabled this level of scalability? I had to create an 800mm x 2000mm print and so I started by actually creating a 800mm x 2000mm file in Illustrator.  The file contained only vectors so my question is:  Can I create my file size dimensions to be smaller as long as it keeps the correct ratio for the final print?  Like I said, vector ONLY, no photos or raster images. How to change the shadow color in Blender Cycles? I want to change the color of the shadow casting by a cube to green. While it's very easy to do it in Blender Internal (you select the lamp, go to the Lamp data header and change the shadow's color in the Shadow panel) in Cycles there're no such options. How to achieve it in Cycles?