This was an answer.
A:
It's a web page, as I understand it. I'm not sure what kind of web page you have in mind, but there are a few possibilities:
The web page is from some sort of website, possibly a game. The "download" button on that page goes to some sort of online file storage site, where your file is downloaded from.
The web page is from a web server of some kind, probably a web server which hosts your own website (i.e. you write the HTML for the page and some other program generates it). If that is the case, you will have a file called index.html in the directory containing your website. This is probably on your hard drive, but it might be something like /var/www/ or /home/username/public_html/ or somewhere like that.
The web page is from a repository of some kind, whether it's a web repository like GitHub or it's just some random file with instructions on how to install something and is just hosted at some remote address (i.e. from a company that sells software that people can download). In that case, it's likely it's going to be on a CDN (Content Delivery Network) somewhere.
If you want to actually find out where the web page is from, use the file command:
$ file /home/username/public_html/index.html
/home/username/public_html/index.html: HTML document text
Q:
SQL Case Statement
I have data in a column of this format:
ID
TS.00232376B01:00236D00
TS.00232376B02:00236D00
TS.00232376B03:00236D00
What I want to do is convert this to the format:
ID | date
TS.00232376B01 | 2019-02-20
TS.00232376B02 | 2019-02-20
TS.00232376B03 | 2019-02-20
The code I am using is:
SELECT ID,
CASE be359ba680
Related links:
Comments