Ankith Reddy has Published 1171 Articles

JDToGregorian() function in PHP

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

17 Views

The JDToGregorian() function converts a Julian day count to a Gregorian date. Syntax jdtogregorian(julian_day); Parameters julian_day − A Julian Day number Return The JDToGregorian() function returns a Gregorian date in format "month/day/year". Example The following is an example − Live Demo Output 1727949 11/11/18

Why doesn't MySQL support millisecond / microsecond precision?

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

465 Views

The millisecond/ microsecond precision wasn’t supported in previous versions like 5.6.4. But now MySQL supports millisecond/ microsecond precision with timestamp, datetime, and time. The official statement. “MySQL now supports fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microsecond precision”. You can check the MySQL version on your ... Read More

call_user_method() function in PHP

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

85 Views

The call_user_method() function call a user method on an specific object. Note − The function is deprecated now. Syntax call_user_method(method, obj, params) Parameters method − Method name obj − Object that method is being called on. params − Array of parameters Alternative ... Read More

How to display current connection info in MySQL?

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

2K+ Views

MySQL provides many functions that give the current connection information. For instance, to know about the current user, use the user() function. Syntax mysql> SELECT CURRENT_USER(); Here is the output that displays the name of the current user. +----------------+ | CURRENT_USER() | +----------------+ | root@% ... Read More

How to create boolean column in MySQL with false as default value?

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

5K+ Views

To create a column with ‘false’ as the default value, we can use the concept of “default” at the time of creation of the table. Note − 0 represents false and 1 represents true. Creating a table using “default” false. mysql> create table TrueFalseTable -> ( ... Read More

Python program to check if binary representation of two numbers are anagram.

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

523 Views

Given two numbers. Our task is to check whether they are anagrams of each other or not in binary representation. We can solve this problem quickly in python using Counter (iterable) method and Dictionary Comparison. Examples Input: a = 8, b = 16 Output : Yes Binary representations ... Read More

How to add comments in MySQL Code?

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

250 Views

We can add comments in MySQL with the help of # symbol. Whenever we write # symbol before any sentence, the whole line will be ignored by MySQL. MySQL supports three type of comments − 1. With the help of # symbol mysql> create table CommentDemo ... Read More

Counters in C#

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

1K+ Views

Counters in C# are performance counters that lets you know about your applications performance. When you will build an application, whether it is a web app, mobile app or even desktop app, you would definitely need to monitor the performance. For performance counters in C#, use the System.Diagnostics.PerformanceCounter class. Set ... Read More

Python Sequence Types

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

6K+ Views

Some basic sequence type classes in python are, list, tuple, range. There are some additional sequence type objects, these are binary data and text string. Some common operations for the sequence type object can work on both mutable and immutable sequences. Some of the operations are as follows − ... Read More

Python Binary Sequence Types

Ankith Reddy

Ankith Reddy

Updated on 30-Jul-2019 22:30:23

3K+ Views

The byte and bytearrays are used to manipulate binary data in python. These bytes and bytearrys are supported by buffer protocol, named memoryview. The memoryview can access the memory of other binary object without copying the actual data. The byte literals can be formed by these options. b‘This is ... Read More

Advertisements