meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 8 months |
| seen | yesterday | |
| stats | profile views | 74 |
|
1d |
asked | Migration of create statement from SQL Server to MySQL |
|
1d |
awarded | Constituent |
|
May 20 |
awarded | Caucus |
|
May 20 |
comment |
Get the 2nd or 3rd occurrence of a value in a delimited string as promised last year, your answer is now marked correct and a +1 vote to your efforts in giving three type of answers in 1 solution. |
|
May 20 |
accepted | Get the 2nd or 3rd occurrence of a value in a delimited string |
|
May 20 |
accepted | convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112) |
|
May 17 |
comment |
convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112) I don't like to store the value as date because I don't want additional information such as the time and GMT information. I just need the yyyymmdd format and unless I can set the date to yyyymmdd format as a data type for my column. |
|
May 17 |
comment |
convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112) Also, I can conclude from your answer that the 1st option will be much more recommended - convert(varchar(8), getdate(), 112) |
|
May 17 |
comment |
Get the 2nd or 3rd occurrence of a value in a delimited string Wow, your update 2 was instead short and sweet. Looks like it will be difficult for other people to provide a even shorter one as a answer. |
|
May 17 |
comment |
convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112) Oh I see, you are right. It seems that I have used a varchar(10) even though I used convert(varchar, getdate(), 112). However and anyway, I do agree with your answer and will mark it correct next week if there are no better answers. |
|
May 17 |
comment |
Get the 2nd or 3rd occurrence of a value in a delimited string I will mark your answer correct next week if I could not find a better answer that can simplified the sql statement. |
|
May 17 |
comment |
Get the 2nd or 3rd occurrence of a value in a delimited string Is it possible to use a single sql statement? |
|
May 17 |
comment |
convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112) I used the Convert function for my default value when I use the Create Table sql statement, which I can see the 2 trailing spaces. |
|
May 17 |
asked | convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112) |
|
May 17 |
asked | Get the 2nd or 3rd occurrence of a value in a delimited string |
|
Apr 25 |
accepted | Getting sql statement to refer to more than 2 tables? |
|
Apr 23 |
comment |
Getting sql statement to refer to more than 2 tables? @RoKa, yeah, there is a typo for the , after el |
|
Apr 23 |
revised |
Getting sql statement to refer to more than 2 tables? typo corrected |
|
Apr 23 |
comment |
Getting sql statement to refer to more than 2 tables? Strange, when you perform Join, I have many missing data not appearing at all, which I experience previously. How do I get all the data back even though it might have NULL values inside it (inside all the columns except the name in the table StaffName)? |
|
Apr 23 |
asked | Getting sql statement to refer to more than 2 tables? |
