Resend Date Field with airSlate SignNow

How to resend to non openers mailchimp

yo yo what's up Caleb back on the youtubes how you guys do in this video we are going to be talking about date date time and time so these are three data types that MySQL has to store dates and times yeah I know as you can tell by SQL likes to really you know separate things out make a lot of extra data types for us simple-minded who like complexity right I'm kidding with joke anywho there are three data types used to do basically the same thing so we have day time date and time and the difference between these are very obscure I'm just playing this obviously okay so let's start with daytime date time is separated into date and time which are essentially the same as these data types so you can store two in one using date/time now there's something particularly special about labeling a column one of these data types and that is that MySQL can work with that data especially it knows that it's working with a date you could in theory not use these data types for example you can have a bar chart column within here you can say something like that and this works fine that's one way you can store dates but overall it's just pretty craptastic you need I need to like become a little bit more professional here this is a very unprofessional approach to do anything of course I'm sure there are certain situations when you will want to store a date as just a sequence of characters in a string but in general you are going to want to use a data type like date/time date or time there's also timestamp which we'll be getting into that in an upcoming video so if you have a column that is of one of these data types how do you give it the data is it date a number or is it a string well we just discussed that it wasn't a string it works a little differently so how do you do it well you actually pass it as a string so you quote it when you give it data now what goes in this has to do with conventions so as we've discussed conventions are just and agreed upon something that everyone uses just to make life easier so for example if I give you something like this and I say it's a time well you would say yeah the time is 6:30 and you know what that means you automatically know that 6:00 well this is how it works in the USA it works differently elsewhere I apologize I am uninformed anyways this is the hour and this is the mist the colon here is just convention we decided hey let's put a colon here if we could just put someone else you know we could have said 6 - 30 or 6-pound 30 is a convention well MySQL has its own way...